Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I use Vlookup extensively and attempted to add a new function, Vlook.
The function should 1) set the 4th argument to false, and 2) return an empty string if the regular formula would return an error. #2 is what I'm having a problem with. Here's my code Function vlook(cell,range,column) vlook = Application.WorksheetFunction.vlookup(cell,range,c olumn,FALSE) if Application.WorksheetFunction.IsError(vlook) then vlook = "" End Function The code works for non-errors, however, returns #VALUE! instead of "" if the formula cannot be resolved. Help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLookup Troubleshooting #N/A | Excel Discussion (Misc queries) | |||
Troubleshooting | Excel Discussion (Misc queries) | |||
Function Troubleshooting | Excel Worksheet Functions | |||
SUMPRODUCT troubleshooting | Excel Worksheet Functions | |||
troubleshooting | Setting up and Configuration of Excel |