Re: $$Excel-Macros$$ Can we find left Value through VLOOKUP formula..

Hi Noorain, Vlookup cant do this.. However u can use the Offset and Match formula combination to do this.. The following link has the solution... Look at the section "Left Lookups" http://www.cpearson.com/excel/TablesAndLookups.aspx Regards, Andy On Wed, Aug 11, 2010 at 2:46 PM, NOORAIN ANSARI

RE: $$Excel-Macros$$ Can we find left Value through VLOOKUP formula..

Hi, No. VLOOKUP only works left to right. If you want to work right to left, you have to use Index / Match Regards - Dave Date: Wed, 11 Aug 2010 14:46:31 +0530 Subject: $$Excel-Macros$$ Can we find left Value through VLOOKUP formula.. From: noorain.ans...@gmail.com To: excel-macros

$$Excel-Macros$$ Can we find left Value through VLOOKUP formula..

Dear Experts, Can we find left Value through VLOOKUP formula..Please need your co-operation.. Example... I want to find Emp Name behalf of Emp ID through only VLOOKUP. Emp Name Emp ID Noorain 22330 Sunil 22331 -- Thanks & regards, Noorain Ansari noorain.ans...@gmail.com --