USING IFNA WITH OTHER LOGICAL FUNCTIONS AND VLOOKUP!

Copper Contributor

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

 

5 Replies

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

@Sergei Baklan  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.

 

@Seaneboy2020 

Perhaps something like

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

@Sergei Baklan Thank you very much for your help.