| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement to find NA()
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement to find NA()
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 |
| Reply |
| 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 | |||
| Keep find box open while in spreadsheet | Excel Discussion (Misc queries) | |||
| What statement to use? | Excel Worksheet Functions | |||
Hybrid Mode
