probably didn't ask the right question. Let's say col 6 is the ST code, IL
and TX for example..i want the lookup to go to the correct state (named
range?) then match the county name and return the county seat.

my thought was us the state code TX as a named range on the table. say you
had this in col 6
TX then vlookup(countyname, TX namedrange,3)
IL then (countyname, IL namedrange,3)
that's one way if it possible
"I Maycotte" wrote:


Is this to ask if you can use vlookup with multiple criteria? Sorry if
I misunderstood you. If this is the case, yes. Just use "&" in the
first argument of the function. If you're asking whether you can
concatenate TX and LU. Then, yes. You'd also use the "&" and make
sure you use double quotes with any string thereafter.

--
Regards,

Isaac Maycotte


--
I Maycotte
------------------------------------------------------------------------
I Maycotte's Profile: http://www.excelforum.com/member.php...o&userid=35604
View this thread: http://www.excelforum.com/showthread...hreadid=562590