| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find & Replace in VB macro | Excel Discussion (Misc queries) | |||
| Find certain text in a column and return statement | Excel Worksheet Functions | |||
| Where can I find a Billing Statement Template for Word or Excel? | New Users to Excel | |||
| How do I find the cell address of the 2nd largest of a set? | Excel Discussion (Misc queries) | |||
| What statement to use? | Excel Worksheet Functions | |||
Threaded Mode
