Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I often code cells to check for error - something like
=IF(ISERROR(VBLOOKUP(parms........)),"",VBLOOKUP(p arms.........)) but I'd like to try to write a function like "CheckIt" which I could invoke as =CheckIt(VBLOOKUP(parms .........) Checkit should allow any type of value as input - since the VBLOOKUP can return text or numeric or anything. It should see if the value is an error and if it is return a blank string, otherwise return the value of the vlookup. A couple of questions: 1 ) Can this be done ? 2) Will the function call evaluate the Vlookup before passing the result to the function ? 3) Can the function accept arguments of any type - that is text or numeric or whatever? Any hints or suggestions are appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Learn VB | Excel Discussion (Misc queries) | |||
Which material is best to learn | Excel Discussion (Misc queries) | |||
To learn about VBA | Excel Discussion (Misc queries) | |||
Learn formulas | Excel Worksheet Functions | |||
How to learn VBA | Excel Discussion (Misc queries) |