# USING IFNA WITH OTHER LOGICAL FUNCTIONS AND VLOOKUP!

Occasional Contributor

# 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

5 Replies

# Re: USING IFNA WITH OTHER LOGICAL FUNCTIONS AND VLOOKUP!

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.

# Re: USING IFNA WITH OTHER LOGICAL FUNCTIONS AND VLOOKUP!

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

# Re: USING IFNA WITH OTHER LOGICAL FUNCTIONS AND VLOOKUP!

Perhaps something like

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

# Re: USING IFNA WITH OTHER LOGICAL FUNCTIONS AND VLOOKUP!

@Sergei Baklan Thank you very much for your help.

# Re: USING IFNA WITH OTHER LOGICAL FUNCTIONS AND VLOOKUP!

@Seaneboy2020 , you are welcome