VLookUp and IFs

I have a code that I look up in one sheet and when it is find I need to put in a forecast date that is in another column, however, if that forecast date cell is empty then I need Excel to go to the n...

Formulas and Functions

HansVogelaar
Jun 25, 2021
anncshaw

For example:

=IFERROR(IF(VLOOKUP(A1,OtherSheet!$A$1:$M$100,13,FALSE)<>"", VLOOKUP(A1,OtherSheet!$A$1:$M$100,13,FALSE), IF(VLOOKUP(A1,OtherSheet!$A$1:$M$100,11,FALSE)<>"", VLOOKUP(A1,OtherSheet!$A$1:$M$100,11,FALSE), IF(VLOOKUP(A1,OtherSheet!$A$1:$M$100,4,FALSE)<>"", VLOOKUP(A1,OtherSheet!$A$1:$M$100,4,FALSE), ""))), "")

Where OtherSheet is the name of the sheet with the lookup range. Adjust the last row 100 if necessary.

HansVogelaar

MVP

Jun 25, 2021

anncshaw

For example:

=IFERROR(IF(VLOOKUP(A1,OtherSheet!$A$1:$M$100,13,FALSE)<>"", VLOOKUP(A1,OtherSheet!$A$1:$M$100,13,FALSE), IF(VLOOKUP(A1,OtherSheet!$A$1:$M$100,11,FALSE)<>"", VLOOKUP(A1,OtherSheet!$A$1:$M$100,11,FALSE), IF(VLOOKUP(A1,OtherSheet!$A$1:$M$100,4,FALSE)<>"", VLOOKUP(A1,OtherSheet!$A$1:$M$100,4,FALSE), ""))), "")

Where OtherSheet is the name of the sheet with the lookup range. Adjust the last row 100 if necessary.

anncshaw

Copper Contributor

Jun 25, 2021

Hi Hans that was my mistake - it is working perfectly thank you so much !!
Kind regards
Ann

Forum Discussion

VLookUp and IFs

Resources