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