Forum Discussion

anncshaw's avatar
anncshaw
Copper Contributor
Jun 25, 2021
Solved

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's avatar
    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's avatar
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's avatar
anncshaw
Copper Contributor
Jun 25, 2021
Hi Hans
I tested this and it works for column 13 but when I remove the date in column 13 I was hoping it would pick up the April date in column 11 but it went straight to the date in column D.




Resources