Do you mean it's faster than the 2 calls that are used in a formula like
=IF(ISNA(VLOOKUP(....)),0,VLOOKUP(...))
That could be, but LOOKUPV(...) certainly can't be faster than =VLOOKUP(...)
On Sat, 19 Feb 2005 11:21:02 -0800, Ola wrote:
You could also use this formula:
=LOOKUPV(C1,A1:B100,2,0,0) or
=LOOKUPV(C1,A1:B100,2,0,"")
But first
1. Press Alt+F11. Insert Module. Copy and Paste the below:
Function LookupV(Lookup_Value, Table_Array As Range, Col_Index_Num,
Range_value, Optional Error_Msg)
LookupV = Application.VLookup(Lookup_Value, Table_Array, Col_Index_Num,
Range_value)
If IsError(LookupV) And Not IsMissing(Error_Msg) Then LookupV =
Error_Msg
End Function
Make sure the VBA code is only 4 rows!
The LOOKUPV formula is Shorter and is Faster then VLOOKUP
Ola Sandstrom
|