ExcelBanter - If statement to find NA()

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If statement to find NA() (https://www.excelbanter.com/excel-worksheet-functions/80855-if-statement-find-na.html)

Barb Reinhardt

If statement to find NA()

I have a VLOOKUP that returns NA. This is not a problem. In another
column, I want to populate it with data from column X if the value in column
AG returns NA from the VLOOKUP. Suggestions?

Thanks,
Barb Reinhardt

Duke Carey

If statement to find NA()

Try

=if(ISNA(AG2),X2, "Not NA!")

"Barb Reinhardt" wrote:

I have a VLOOKUP that returns NA. This is not a problem. In another
column, I want to populate it with data from column X if the value in column
AG returns NA from the VLOOKUP. Suggestions?

Thanks,
Barb Reinhardt

All times are GMT +1. The time now is 04:52 AM.