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 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