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
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 13, 2020

Seaneboy2020 

You may use ISNA() which returns TRUE or FALSE depends on if you have #N/A or not, and combine it as with any other condition which returns TRUE or FALSE.

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