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 IFNA, IF, AND and possibly OR in order to achieve my desired result but I'm not sure in what order.

 

Is anyone able to help please?

 

Thanks

 

excel
Formulas and Functions

5 Replies

  • 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.

       

Resources