A Second Lookup If The First Fails

[MrRosco]

Hey everyone,

My spreadsheet is getting rather large and slowing down some what, mainly due to several VLOOKUP's running which i know takes a lot of processing power,
what i am trying to achieve using INDEX/MATCH is this =IFERROR(VLOOKUP(L:L,dItemLookUp,2,FALSE),VLOOKUP(L:L,dNPDItems,2,FALSE))

as you can see if the first lookup fails to find a match it will then reference another table.

any help on this will be greatly appreciated.

Thanks
Rosco

 

[Special-K99]

For a start change the range reference L:L and place row numbers in there to speed it up, e.g. L1:L1000, adjust as required dependend on maximum number of rows.

 

[Joe4]

For a start change the range reference L:L and place row numbers in there to speed it up, e.g. L1:L1000, adjust as required dependend on maximum number of rows.

It shouldn't even be that. The first argument should be a single cell, not a whole range - it is what value you are trying to look up.
https://exceljet.net/excel-functions/excel-vlookup-function

 

[Special-K99]

It shouldn't even be that. The first argument should be a single cell, not a whole range - it is what value you are trying to look up.
https://exceljet.net/excel-functions/excel-vlookup-function

Giood point, missed that.

 

[MrRosco]

It shouldn't even be that. The first argument should be a single cell, not a whole range - it is what value you are trying to look up.
https://exceljet.net/excel-functions/excel-vlookup-function

Thanks for your help, after playing around abit i have managed to work it out using Index and Match.
Seems to be working fine.

=IFERROR(INDEX(dProductionPool[Production Pool],MATCH(Pipeline_2018!L:L,dProductionPool[Item Code],0)),(INDEX(dNPDItems[SO99 Production Pool],MATCH(Pipeline_2018!L:L,dNPDItems[Item No.],0))))

Rosco