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