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
|