View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Vito
 
Posts: n/a
Default VLookUp / 2 Tables


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