=OFFSET($A$1,MATCH(E2,$B$2:$B$8,0),0) or =INDEX($A$2:$B$8,MATCH(E2,$B$2:$B$8,0),1)
On Fri, Jun 10, 2011 at 3:14 AM, hanumant shinde <arsfan2...@yahoo.co.in>wrote: > Hi friends, > > this is really really urgent and very very very IMP for me so quick help > would > be really really appreciated. > > Name No > a 1 > s 2 > d 3 > f 4 > g 5 > h 6 > j 7 > data is like above i.e. first Name and then No. i want to Vlookup for No. > values > and get Name but without moving any col or modifying anything. i.e > something > like =VLOOKUP(E2,$B$2:$D$8,3,0) but this will not work as in a range > parameter > No. column is not at 1st place. > > please find the attached workbook for more details. > let me know if you need anything else. > > -- ---------------------------------------------------------------------------------- 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
ctv_Vlookup_to_LEFT.xls
Description: MS-Excel spreadsheet