Forum Discussion

Seaneboy2020's avatar
Seaneboy2020
Copper Contributor
Nov 13, 2020

USING IFNA WITH OTHER LOGICAL FUNCTIONS AND VLOOKUP!

I'm trying to combine a VLOOKUP formula with other logical functions, so that if the look up returns an #N/A, depending on the value of other cells, this may be correct.   I think I need to use IFN...
excel
Formulas and Functions
Seaneboy2020's avatar
Seaneboy2020
Copper Contributor
Nov 13, 2020

SergeiBaklan  Thank you very much for your response.

 

Would you know in what order I would need to nest the functions, within the formula?

 

The argument I am trying to create is:

 

"If the VLOOKUP returns #N/A, and cell ** isn't blank, then return this. And if the VLOOKUP returns #N/A, and cell ** is blank, then return this. And if the VLOOKUP returns #N/A, then return this.

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 13, 2020

Seaneboy2020 

Perhaps something like

=IF( ISNA( VLOOKUP() ), IF(cell="", this, that), VLOOKUP() )

Resources