Re: $$Excel-Macros$$ Re: VLOOKUP FROM A RANGE OF SHEETS
Dear Vivek, Please find attached example sheet of Global Vlookup. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jun 11, 2012 at 8:59 AM, Vivek vivek.j...@gmail.com wrote: How to use the Vlookup function in a separate excel file, to search for file number form the client index file, where data are stored in multiple sheets. On Friday, 8 June 2012 10:12:45 UTC+5:30, Vivek wrote: I have created a file index , with separate sheets alphabetically. Now I want to use the vlookup function in a new file, wherein I would type the clients name , and it should lookup the file number from the index file. Is it possible? Thanks Regards... CA Vivek Jain, FCA, DISA (ICAI) -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Global_Vlookup(Vivek).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: VLOOKUP FROM A RANGE OF SHEETS
How to use the Vlookup function in a separate excel file, to search for file number form the client index file, where data are stored in multiple sheets. On Friday, 8 June 2012 10:12:45 UTC+5:30, Vivek wrote: I have created a file index , with separate sheets alphabetically. Now I want to use the vlookup function in a new file, wherein I would type the clients name , and it should lookup the file number from the index file. Is it possible? Thanks Regards... CA Vivek Jain, FCA, DISA (ICAI) -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Re: VLOOKUP FROM A RANGE OF SHEETS
Dear All, Please find enclosed herewith the sample file. Thanks CA Vivek Jain. On Friday, 8 June 2012 10:12:45 UTC+5:30, Vivek wrote: I have created a file index , with separate sheets alphabetically. Now I want to use the vlookup function in a new file, wherein I would type the clients name , and it should lookup the file number from the index file. Is it possible? Thanks Regards... CA Vivek Jain, FCA, DISA (ICAI) -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com sample file register .xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Re: VLOOKUP FROM A RANGE OF SHEETS
YOu could use something like this Use in B1 where you put the client name in A1 =INDEX(INDIRECT('[sample file register .xlsx]LEFT(A1,1)'!$A$2:$A$20),MATCH(A1,INDIRECT('[sample file register .xlsx]LEFT(A1,1)'!$B$2:$B$20),0)) Regards, Sam Mathai Chacko On Sat, Jun 9, 2012 at 5:06 PM, Vivek vivek.j...@gmail.com wrote: Dear All, Please find enclosed herewith the sample file. Thanks CA Vivek Jain. On Friday, 8 June 2012 10:12:45 UTC+5:30, Vivek wrote: I have created a file index , with separate sheets alphabetically. Now I want to use the vlookup function in a new file, wherein I would type the clients name , and it should lookup the file number from the index file. Is it possible? Thanks Regards... CA Vivek Jain, FCA, DISA (ICAI) -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Sam Mathai Chacko -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: VLOOKUP FROM A RANGE OF SHEETS
Please see attached 2012/6/9 Vivek vivek.j...@gmail.com: Dear All, Please find enclosed herewith the sample file. Thanks CA Vivek Jain. On Friday, 8 June 2012 10:12:45 UTC+5:30, Vivek wrote: I have created a file index , with separate sheets alphabetically. Now I want to use the vlookup function in a new file, wherein I would type the clients name , and it should lookup the file number from the index file. Is it possible? Thanks Regards... CA Vivek Jain, FCA, DISA (ICAI) -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com VLOOKUP.xlsm Description: Binary data
Re: $$Excel-Macros$$ Re: VLOOKUP FROM A RANGE OF SHEETS
Please replace previous Please see attached 2012/6/9 ChilExcel chilexcel...@gmail.com: Please see attached 2012/6/9 Vivek vivek.j...@gmail.com: Dear All, Please find enclosed herewith the sample file. Thanks CA Vivek Jain. On Friday, 8 June 2012 10:12:45 UTC+5:30, Vivek wrote: I have created a file index , with separate sheets alphabetically. Now I want to use the vlookup function in a new file, wherein I would type the clients name , and it should lookup the file number from the index file. Is it possible? Thanks Regards... CA Vivek Jain, FCA, DISA (ICAI) -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com VLOOKUP_OK.xlsm Description: Binary data