Forum Discussion

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
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
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.
anncshaw
Copper Contributor
Jun 25, 2021
Hi Hans
Thank you I will try this and respond !
Much appreciated 🙂
Ann