Function
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Monday, May 14, 2012 12:41 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Need help-- Related to UDF
Hello Amol,
Sounds like you are asking for something
Hello Amol,
Sounds like you are asking for something like this:
Function LookupSomething(LookupValue, TableArray)
Const ColIndex 3, RangeLookup = True
LookupSomething = WorksheetFunction.VLookup(LookupValue, TableArray,
ColIndex, RangeLookup)
End Function
Modify the Const line for the VLO
Give a couple of examples of your vlookup formula(s)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Amol Jadhav
Sent: Monday, May 14, 2012 8:42 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help-- Related to UDF
Hi Experts,
I need your help
