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