| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Replacing #N/A with other text
I'm sure this is very easy to do, but it's not intuitively obvious and I
can't seem to tailor my question in Excel to get a relevant answer. I'm using VLOOKUP and I am successful in getting matched values. But I'd like to change the "#N/A" with a value such as "No Data". How do I do this? Thanks, Dave |
|
#2
|
|||
|
|||
|
=if(isna(vlookup...),"No Data",vlookup....)
************ Anne Troy www.OfficeArticles.com "Dave" wrote in message ... I'm sure this is very easy to do, but it's not intuitively obvious and I can't seem to tailor my question in Excel to get a relevant answer. I'm using VLOOKUP and I am successful in getting matched values. But I'd like to change the "#N/A" with a value such as "No Data". How do I do this? Thanks, Dave |
|
#3
|
|||
|
|||
|
Thanks, Anne; worked great. ( I knew it was something easy).
Dave "Anne Troy" wrote: =if(isna(vlookup...),"No Data",vlookup....) ************ Anne Troy www.OfficeArticles.com "Dave" wrote in message ... I'm sure this is very easy to do, but it's not intuitively obvious and I can't seem to tailor my question in Excel to get a relevant answer. I'm using VLOOKUP and I am successful in getting matched values. But I'd like to change the "#N/A" with a value such as "No Data". How do I do this? Thanks, Dave |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Replacing text in Excel files on disk? | Excel Discussion (Misc queries) | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Hybrid Mode
