If statement to find NA()

[Barb Reinhardt]

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]

Try

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