Hi Taxmom

as per my original reply to your last thread - from my understanding of your
question you're going to need to insert a new column into the 2nd worksheet
either before the city name or after the county name and concatenate these
two fields so that they match what you have in the first column of your 1st
worksheet ... you can then use this column as the first column in your
VLOOKUP table and return the information from the gross & tax amount fields
e.g.
if you have in 1st worksheet
city/county....gross....tax
Perth/WA....=IF(ISNA(VLOOKUP(A1,Data!$C$2:$E$1000,2,0)), "",VLOOKUP(A1,Data!$C$2:$E$1000,2,0))
(and a similar formula for tax)

and in your second worksheet
city....county...NewColumn....gross....tax
Perth...WA.....=A2&"/"&B2..1000.....20

does this work?

Cheers
JulieD


"taxmom" wrote in message
...
1stworksheet
City/Couty Gross Tax

county name (formula) Formula
city Name (formula Formula

2nd worksheet (data)
City name County Name Gross amount tax amount

I need to match the city county name from worksheet 1 with the city county
name in worksheet 2 and then bring over from the data worksheet the
amounts
from column 4 & 5.

What would I use? I have a Vlookup but it is only searching for the city
name, and I need both. How would I link the search for city and the
search
for county?

I have not been able to come up with the right formula to make this work.
I
have been trying for days.