Hi Jai, You can use INDEX and MATCH:
=INDEX(column range,MATCH(what,where,0)) 0 at the end specifies exact match. MATCH() also support wildcards. MATCH returns the relative position of the match, INDEX returns the value from the cell in column range on the same row. This opens up more possibilities than vlookup, too. You can easily get your final value from the next or some other row (perform arithmetic with the MATCH result), or even another table or sheet (the column range can point anywhere). Index/Match can also replace HLOOKUP for horizontal lookups. Another formula combination is Offset/Match, but Offset is a volatile function (always recalculated) and best to reserve for when it is the best alternative for the task. Offset can return a whole range of cells, rather than just one value, which could be one reason to keep this combination in your toolbox. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Jai Sent: Friday, January 06, 2012 2:18 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ want to solution of Vlookup limitation you use only =vlookup formula On Fri, Jan 6, 2012 at 3:30 PM, Ashish Bhalara <ashishbhalar...@gmail.com> wrote: Dear experts, There are a limitation of vlookup that it find out the value only from right side of the lookup_value. I require the value from left side of lookup_value. Is there any solution for this type of query? Thanks & regards. Ashish Bhalara -- 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 -- 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 -- 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
