=IF(NOT(ISNA(VLOOKUP(B2,G1:I18,3,0))),VLOOKUP(B2,G 1:I18,3,0),VLOOKUP(B2,J1:K15,2,0))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Karen" wrote in message
...
I have 2 columns and I am trying to create a validation in which my 2nd
column relies on the input of the 1st. That's fine. But, I need to do a
lookup in two different tables on the same sheet. Is what I'm trying to do
allowed in Excel. I attempted a formula in my source but I get errors.
It's
not a parenthesis error or anything like that. Can someone please help?
Thanks.

=IF(INDIRECT(VLOOKUP(B2,G1:I18,3,0)),(VLOOKUP(B2,J 1:K15,2,0)))