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
=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.inwrote:
Hi friends,
this is really really urgent and very very very IMP for me so quick help
would
be really really appreciated.
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.inwrote: