Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extend Custom function
Hi
Someone was kind enough to post this custom function. What it does is assess if a lookup is valid if it is it does one thing, if not another. However if I have a fomula which either the true or false component returns an #NA then I get a #VALUE! Error. I don't want to wrap the custom function with an if iserror formula as the idea was to make the long formula shorter. Can someone provide some more insight? Lookup here =checkit(A7,VLOOKUP(A7,YesSheet!$A$2:$B$30,2,0),VL OOKUP(A7,NoSheet!$A $2:$B$30,2,0)) Custom function here Function Checkit(target As String, MatchResults As String, NonMatchResults As String) Select Case target Case "A", "B", "C" Checkit = MatchResults Case Else Checkit = NonMatchResults End Select End Function |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extend the number of arguments of a function | Excel Worksheet Functions | |||
How to extend Excel with custom data provider? | Excel Programming | |||
Automatically Extend Formula in Count function with Additional Row | Excel Discussion (Misc queries) | |||
Creating a custom function to interpret another custom engine func | Excel Programming | |||
Excel - option to extend function in cell to column | Excel Worksheet Functions |