Nov 13 2020 08:39 AM
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
Nov 13 2020 09:08 AM
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.
Nov 13 2020 09:24 AM
@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.
Nov 13 2020 09:29 AM
Nov 13 2020 09:43 AM
@Sergei Baklan Thank you very much for your help.
Nov 13 2020 11:26 AM
@Seaneboy2020 , you are welcome