I have 2 tables - Refmam1 and Refman2

My lookup value is in ColA. I Want to return the value in ColB

Is it possible to use the vlookup so that it checks Refman1 and Refman2 ?

Thank you in advance.

You can try:

Double-Check spelling of Sheet Tab names.

=IF(COUNTIF(Refman1!A:A,A1)0,VLOOKUP(A1,Refman1!A :B,2,0),IF(COUNTIF(Refman2!A:A,A1)0,VLOOKUP(A1,Re fman2!A:B,2,0),"Not
Found"))

Adjust cell references to suit.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=502233

Hi Carl,

If I understand correctly..

=IF(ISNA(VLOOKUP(F1,A1:B5,2,0)),VLOOKUP(F1,D1:E5,2 ,0),VLOOKUP(F1,A1:B5,2,0))

Where F1 is the lookup value and A1:B5 is Refman1 and D1:E5 is Refman2.
So if the F1 lookup value of Ref1 returns #N/A it will return a value from
Ref2 and if no number match there then #N/A will be returned from the Ref2
lookup.

HTH
Regards,
Howard

"carl" wrote in message
...
I have 2 tables - Refmam1 and Refman2

My lookup value is in ColA. I Want to return the value in ColB

Is it possible to use the vlookup so that it checks Refman1 and Refman2 ?

Thank you in advance.