I think the main issue was the very large lookup ranges for that formula and other formulas, but you are right that a built-in function solution would probably be faster.
I did not analyze what the VBA function was doing, but another powerful lookup function is DGET. It needs a separate criteria range, but can handle any combination of sophisticated criteria. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Damimkader S. Meeran Sent: Thursday, March 22, 2012 10:40 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Arry Formula help Hi, I checked the VBAVlookup custom function, it is looking up using usernumber and the layout on the Txtlist sheet. If this is slowing down the performance of the application, I would recommend creating a column which concatenates the usernumber and layout column on the "txt list" sheet and on the "Setts" sheet write a vlookup combined with a concatenate function to accomplish what you are looking for (multivalued lookup) Please let me know if that helps or if you need more help. Regards, Damim On Thursday, March 22, 2012 10:26:58 PM UTC+5:30, Avinash wrote: Dear Experts, please open attached excel sheet and go to the Setts sub sheet for better understanding. basically i want to perform multi value lookup for the specific user. and to get this thing done i tried to Google it. now i got the VBA code for the multivalue lookup but it is taking too much time to give me the results. can anyone please help me with this and tell me how it works ( there is a VBA code in the attached file) please help me and thanks Don and Noorain for all your support. and those formulas and codes which you have given me are very very very very usefull in my work thnx a ton guys. Regards, Avinash -- 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
