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
