| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom function to simplify vlookup formula
I want to have custom functions that will simplify vlookups (and other
formulas) which have imbedded "if" formulas to eliminate errors. e.g.This formula provided in a previous posting is ugly and somewhat annoying: =IF(ISERROR(VLOOKUP($A2,Stock,2,0)),"",VLOOKUP($A2 ,Stock,2,0)) Can I replace it with a custom function that works the same but looks something like this: =MyVLookup($A2,Stock,2,0) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| simplify VLOOKUP with conditions | Excel Worksheet Functions | |||
| Custom function to simplify Index(match)) formula | Excel Discussion (Misc queries) | |||
| Custom Function VLookup | Excel Discussion (Misc queries) | |||
| simplify a vlookup function | Excel Worksheet Functions | |||
| Simplify Vlookup function in Excel | Excel Worksheet Functions | |||
Threaded Mode
