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/80851-re-if-statement-find-na.html)

Barb Reinhardt

If statement to find NA()

Now why didn't I think of that.

Thanks,
Barb

"Duke Carey" wrote:

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:59 AM.