| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help With VLookup Please
VLOOKUP returns #NA when the searched value is not found. If you want to
replace #NA by something else, follow Eric's suggestion! You are welcome! Thanks for the feedback! Stefi Clicking the YES button will be appreciated. €žAndy€ť ezt Ă*rta: Hi Stefi That's awesome! Works perfectly. Thanks! One question. Is there any way you can tell if it doesn't find a match when it is searching a particular value? Regards, Andy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup problem - unable to get the vlookup property | Excel Programming | |||
| using a vlookup to enter text into rows beneath the vlookup cell | Excel Programming | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Threaded Mode
