auto paste text in similar columns

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
 
F

Frank Kabel

Hi
sound like VLOOKUP.
try something like
=VLOOKUP(A1,'county_tab'!$A$1:$D$1000,col_with_base_amount,0)
where A1 is your customer no., county_tab your worksheet with the
county taxable worksheet (change the range according to your need, the
left most column has to be the customer no.). col_with_base_amount is
your column index for the base amount

Frank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula finder (more than 1 reply is ok) 1
auto paste text in similar columns 1
Auto input in different columns 0
Auto input? 0
copying form data 2
Auto enter (more than 1 reply ok) 1
extract data using a macro? 1
Help please 1

Top