You can Use LooKUP Function if Your data is Sorted
=LOOKUP(E3,$B$3:$B$21,$A$3:$A$21) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Venkat CV Sent: Thursday, July 28, 2011 5:06 PM To: excel-macros@googlegroups.com Cc: anil.bha...@tatacommunications.com Subject: Re: $$Excel-Macros$$ Reverse Vlookup 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> 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 <mailto:anil.bha...@tatacommunications.com> 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 <><><><><><><><><><><><><><><><><><><><><><> 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 -- ---------------------------------------------------------------------------------- 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
ReverVlookup.xls
Description: MS-Excel spreadsheet