I tried this and it is returning the row above the correct one. the rows a
re sorted and if you add "True" it returns the same error, "False" returns
N/A. can't understand this anomoly?

any ideas?

"SimonCC" wrote:

On the 2nd sheet where there are 6000 records, insert a column to the very
left to concatenate both the state and county info. In the first sheet with
30000 record, there's no need to create an extra column to concatenate the
info. In the VLOOKUP formula, can simply use StateCell&CountyCell for the
first argument. Also feel free to add a ISNA formula to check for error.

-Simon

"reno" wrote:

have xl worksheet with 30000 rows w/25 cols all containing static demographic
data. i want to add another col to add the county seat to each record. i
have another worksheet that contains the 6000 counties and county seats. i
want to use a lookup to fill in the county seat on first w/s.

there are duplicate county seat names in several states, e.g. Adams appears
in 7 instances, i want to ensure the Texas seat goes with the Texas counties
on the first w/s.

if the states are two letters you could use vlookup(statename,
country,3)...could you use concatenation say for TX to add LU on the end such
that it becomes TXLU that is then substituted into the vlookup function?
thanks