Do you or anyone else have such detailed ebook or PPT on excel functions? If yes, please share.
Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 31 August 2012 13:07 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help Dear Sriram, I have created a Ebook of Vlookup (Magic of Vlookup), There are 35 types of vlookup in it. i will share shortly with group,this is because some design part is still pending. See a Snap shot.... Sr.No Types of Vlookup Status 1 Simple Vlookup Yes 2 Vlookup+Match Yes 3 Vlookup+Column Yes 4 Vlookup+if condition Yes 5 Vlookup+Max/Min Yes 6 Vlookup with Sorting Yes 7 Vlookup+Exact Yes 8 Vlookup+Choose Yes 9 Vlookup+Array Yes 10 Vlookup+Large/Small Yes 11 Vlookup+Wild Card Yes 12 Vlookup+"?" Yes 13 Vlookup+indirect Yes 14 Vlookup+Row() Yes 15 Vlookup+iferror(Global) Yes 16 Vlookup+Sumproduct Yes 17 Vlookup+offset Yes 18 Vlookup+Index Yes 19 Vlookup+substitute Yes 20 Vlookup+Char Yes 21 Vlookup+Value/Int Yes 22 Vlookup+Trim/Clean Yes 23 Vlookup+Multiple Lookup Yes 24 Vlookup+Hyperlink Yes 25 Vlookup+Concatenate Yes 26 Vlookup+Left/right/Mid Yes 27 Vlookup+N Yes 28 Vlookup+Edate Yes 29 Vlookup+EOMonth Yes 30 Vlookup+Round/Mround Yes 31 Vlookup+SQRT Yes 32 Vlookup+Approximate value Yes 33 Vlookup+"" Yes 34 Vlookup Multiple Yes 35 Vlookup+Subtotal Yes ================================== On Fri, Aug 31, 2012 at 12:22 PM, sriram ji <sriramg...@gmail.com<mailto:sriramg...@gmail.com>> wrote: Dear Excel Guru, May I know how to vlookup 2003 Excel to 2007 excel... Thanks & Regards, Sriram G (chennai) -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros%2bunsubscr...@googlegroups.com>. -- With Regards, Noorain Ansari http://<http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http://<http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com> -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros+unsubscr...@googlegroups.com>. ________________________________ Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.