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