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=484825

=IF(ISNA(vlookup_formula1),IF(ISNA(vlookup_formula 2),IF(ISNA(vlookup_formula
3),"",vlookup_formula3),vlookup_formula2),vlookup_ formula1)

--

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=484825

Thanks for your help


--
Robo
------------------------------------------------------------------------
Robo's Profile: http://www.excelforum.com/member.php...o&userid=12058
View this thread: http://www.excelforum.com/showthread...hreadid=484825

Bob, thanks for your help but....


"=IF(ISNA(vlookup(a39,grml_owner,3,false),IF(ISNA( vlookup(a39,gt_owner,3,false),IF(ISNA(vlookup(a39, er_owner,3,false),"",vlookup(a39,er_owner,3,false) ,vlookup(a39,gt_owner,3,false),vlookup(a39,grml_ow ner,3,false)


The formula does not work at ,"",

Any ideas?

Thanks

Rob


--
Robo
------------------------------------------------------------------------
Robo's Profile: http://www.excelforum.com/member.php...o&userid=12058
View this thread: http://www.excelforum.com/showthread...hreadid=484825