Auto enter (more than 1 reply ok)

[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?

 

[Kent]

Hi Chrystal:

I think this is one where I'd need to see the sheets to be
elegant or at least a mock up of what could be in the
TaxList. I say this gingerly because I don't want to be
accused of snatching client data or some such.

If the customer ID is in this tax list or you can put in
the county on the fly, then it's a simple lookup. If not,
then more info on the construct of these two sheet is
needed to determine a solid workable solve for you.

Excel Support Technician
www.canhelpyou.com