Thanks Daniel, It's amazing and Finance people on this group will be grateful to you, just one more request to get this function inbuilt in excel, could you please share how and where to save the below macro.
Because I tried but not getting answer and it shows Error. Regards, Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Daniel Sent: Thursday, July 28, 2011 06:16 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Reverse Vlookup HI, Try the below function ; the parameters are the same as those of the VLOOKUP function : Function RLookup(ToSearch, rg As Range, col As Long, Optional ProxVal) Dim RightRange As Range If IsError(ProxVal) Then ProxVal = 1 Set RightRange = rg.Resize(, 1).Offset(, rg.Columns.Count - 1) With Application If ProxVal = 1 Then RLookup = .Index(rg, .Match(ToSearch, RightRange, 1), rg.Columns.Count - col + 1) Else RLookup = .Index(rg, .Match(ToSearch, RightRange, 0), rg.Columns.Count - col + 1) End If End With End Function Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Anil Bhange Envoyé : jeudi 28 juillet 2011 14:23 À : excel-macros@googlegroups.com Objet : RE: $$Excel-Macros$$ Reverse Vlookup Thanks XlS S, Venkat and other members, I have the solution for the query but I thought it would be great to create the VBA Function which help as a formula in excel. So could you please help me with VBA code where we all could just type something like "=RLOOKUP(........) and will get the result Regards, Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> [mailto:excel-macros@googlegroups.com]<mailto:[mailto:excel-macros@googlegroups.com]> On Behalf Of XLS S Sent: Thursday, July 28, 2011 05:44 PM To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> Subject: Re: $$Excel-Macros$$ Reverse Vlookup Try this .......... please find the attachment On Thu, Jul 28, 2011 at 5:05 PM, Venkat CV <venkat1....@gmail.com<mailto:venkat1....@gmail.com>> wrote: Hi Anil, Look Attached it will help u... Best Regards, Venkat Chennai On Thu, Jul 28, 2011 at 4:16 PM, Anil Bhange <anil.bha...@tatacommunications.com<mailto:anil.bha...@tatacommunications.com>> wrote: Hi All, Could you help me with VB code for Reverse Vlookup function command where we can lookup value from Right to Left. Some similar to Vlookup but lookup from Right to Left. Please give me a function code so that I can able to save this in Personal workbook and use in all excel file. Anil Bhange Business Planning & Management Reporting Financial Planning & Analysis, TATA Communications Ltd. 6th Floor, B Wing, Bandra Kurla Complex, Bandra (East), India ' Desk : + 91 22 6659 2320 | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 anil.bha...@tatacommunications.com<mailto:anil.bha...@tatacommunications.com> -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com<http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com<http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com<http://exceldailytip.blogspot.com/> To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ......................... -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
