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 VLOOKUP presets that you want.
If desired, you can create defined names for all your TableArray ranges in
the other workbook, and then the function could be called like this:
=LookupSomething($C2,Where)
Where Where can be the defined name.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Amol Jadhav
Sent: Monday, May 14, 2012 6:42 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help-- Related to UDF
Hi Experts,
I need your help to create UDF
I want to create udf which will work as same as vlookup. Here my lookup
value will be from column C for ex. $C2, my table array range will be from
different workbook called export ,my column index no also fixed i.e 3.
So my lookup value is fixed column, my table array range -- my table array
range may vary so it must be dynamic and my column index no also fixed
I know vlook up function and its works fine for me. but issue is I have team
of 30 member they don't know anything about excel. So it will be great help
for me. so I will just put my udf and drag it and I will get output from
export sheet
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
