Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multiple if or multiple vlookup
I have 3 data sources and one summary page. I want to lookup a cell in my summary page and find the result in either one of my 3 data sources(All within the same spreadsheet) In summary I need if vlookup data source 1 is #N/A THEN vlookup data source 2, if data source 2 is #N/A vlookup data source 3. If not in all 3 data sources "Not Found" I this possible? Thanks Robo -- Robo ------------------------------------------------------------------------ Robo's Profile: http://www.excelforum.com/member.php...o&userid=12058 View this thread: http://www.excelforum.com/showthread...hreadid=484827 |
#2
|
|||
|
|||
Multiple if or multiple vlookup
=IF(ISNA(VLOOKUP(source1)),VLOOKUP(source1),IF(ISN A(VLOOKUP(source2)),VLOOKUP(source2),VLOOKUP(sourc e3)))
Jerry Robo wrote: I have 3 data sources and one summary page. I want to lookup a cell in my summary page and find the result in either one of my 3 data sources(All within the same spreadsheet) In summary I need if vlookup data source 1 is #N/A THEN vlookup data source 2, if data source 2 is #N/A vlookup data source 3. If not in all 3 data sources "Not Found" I this possible? Thanks Robo |
#3
|
|||
|
|||
Multiple if or multiple vlookup
I get #NAME? Any thoughts? Rob -- Robo ------------------------------------------------------------------------ Robo's Profile: http://www.excelforum.com/member.php...o&userid=12058 View this thread: http://www.excelforum.com/showthread...hreadid=484827 |
#4
|
|||
|
|||
Multiple if or multiple vlookup
see response in .misc
-- HTH RP (remove nothere from the email address if mailing direct) "Robo" wrote in message ... I have 3 data sources and one summary page. I want to lookup a cell in my summary page and find the result in either one of my 3 data sources(All within the same spreadsheet) In summary I need if vlookup data source 1 is #N/A THEN vlookup data source 2, if data source 2 is #N/A vlookup data source 3. If not in all 3 data sources "Not Found" I this possible? Thanks Robo -- Robo ------------------------------------------------------------------------ Robo's Profile: http://www.excelforum.com/member.php...o&userid=12058 View this thread: http://www.excelforum.com/showthread...hreadid=484827 |
#5
|
|||
|
|||
Multiple if or multiple vlookup
Did you replace Source1-3 with your real tables
-- Regards, Peo Sjoblom (No private emails please) "Robo" wrote in message ... I get #NAME? Any thoughts? Rob -- Robo ------------------------------------------------------------------------ Robo's Profile: http://www.excelforum.com/member.php...o&userid=12058 View this thread: http://www.excelforum.com/showthread...hreadid=484827 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP and multiple columns | Excel Discussion (Misc queries) | |||
how do I use vlookup for multiple occurrences of the same value | Excel Worksheet Functions | |||
Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
vlookup with multiple lines of same value | Excel Worksheet Functions | |||
Multiple Vlookup? | Excel Worksheet Functions |