Its working good. thanks......
regards kannan V On Fri, Jun 10, 2011 at 7:43 AM, STDEV(i) <setiyowati.d...@gmail.com> wrote: > =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 > -- ---------------------------------------------------------------------------------- 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
