Multiple if or multiple vlookup

[Robo]

I have 3 data sources and one summary page. I want to lookup a cell i
my summary page and find the result in either one of my 3 dat
sources(All within the same spreadsheet)

In summary I need

if vlookup data source 1 is #N/A THEN vlookup data source 2, if dat
source 2 is #N/A vlookup data source 3. If not in all 3 data source
"Not Found"

I this possible?

Thanks

Rob

 

[Jerry W. Lewis]

=IF(ISNA(VLOOKUP(source1)),VLOOKUP(source1),IF(ISNA(VLOOKUP(source2)),VLOOKUP(source2),VLOOKUP(source3)))

Jerry

 

[Robo]

I get #NAME?

Any thoughts?

Rob

 

[Bob Phillips]

see response in .misc

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Peo Sjoblom]

Did you replace Source1-3 with your real tables

--
Regards,

Peo Sjoblom

(No private emails please)