Formula finder (more than 1 reply is ok)

  • Thread starter Thread starter Crystal
  • Start date Start date
C

Crystal

I have a workbook that I input customer sales. I then have to look up in
another tab (same workbook) what county that customer is taxable in. I then
have to copy the base sales amount into that county. Is there a way for me
to merge the infomation on the county taxable worksheet with the master
sales data worksheet so that when I input the following scenario it would
automatically copy the base amount I enter into the corresponding county
taxable column?:

Customer Sales Tax Taxable in (County Name)
ABC Co $1.00 .08 $1.00 (Automatically
entered due to formula?)

Can anyone tell me exactly what the formula would be? Let's say the main
sheet is called Ledger (where I actually do the entering) and the taxable
information is called TaxList. What would I enter to get it to recognize
that customer ABC is taxable in county XYZ? Any ideas?
 
More than many postings not ok. I see a copy of this question in every newsgroup I read.
Don't waste peoples time.
 
Back
Top