Multiple if or multiple vlookup

[Robo]

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

[Jerry W. Lewis]

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

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

[Robo]

I get #NAME?

Any thoughts?

Rob

[Bob Phillips]

see response in .misc

--

HTH

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


"Robo" <Robo.1yhlkn_1131972005.3545@excelforum-nospam.com> wrote in message
news:Robo.1yhlkn_1131972005.3545@excelforum-nospam.com...
>
> 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
>

[Peo Sjoblom]

Did you replace Source1-3 with your real tables

--
Regards,

Peo Sjoblom

(No private emails please)


"Robo" <Robo.1yhnno_1131974704.8146@excelforum-nospam.com> wrote in message
news:Robo.1yhnno_1131974704.8146@excelforum-nospam.com...
>
> 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
>