Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLookUp / 2 Tables
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLookUp / 2 Tables
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
can vlookup search multiple data tables | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
VLookUp Tables | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |