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 modi
=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 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
Its working good. thanks..
regards
kannan V
On Fri, Jun 10, 2011 at 7:43 AM, STDEV(i) 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
> wrote:
>
>> Hi friends,
>>
>> this is really