Great Haseeb, Can you tell me something about CHOOSE,OFFST function
On Fri, Jul 29, 2011 at 5:07 AM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:
> Hello Anil.
>
> You can use VLOOKUP for Reverse Lookup. Consider A1:B20 is the data. E2 is
> the Lookup_Value from Col_B. So use this,
>
> =
Hello Anil.
You can use VLOOKUP for Reverse Lookup. Consider A1:B20 is the data. E2 is
the Lookup_Value from Col_B. So use this,
=VLOOKUP(E2,CHOOSE({1,2},$B$2:$B$20,$A$2:$A$20),2,0)
CHOOSE({1,2},$B$2:$B$20,$A$2:$A$20) will give the array of Col_B value first
then Col_A. So VLOOKUP will work as
Hi Anil
Find attach
Try
=LOOKUP(2,1/($A$2:$A$12=D3),$B$2:$B$12)
Thanks
Mahesh
On Thu, Jul 28, 2011 at 4:16 PM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:
> Hi All,
>
> ** **
>
> Could you help me with VB code for Reverse Vlookup function command where
> we can lookup value fro
...@tatacommunications.com
Subject: Re: $$Excel-Macros$$ Reverse Vlookup
Hi Anil,
Look Attached it will help u...
Best Regards,
Venkat
Chennai
On Thu, Jul 28, 2011 at 4:16 PM, Anil Bhange
wrote:
Hi All,
Could you help me with VB code for Reverse Vlookup function command where we
can lookup value
l Bhange
>
> IP Phone - 512320 | Mobile - 90290 32123
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Daniel
> *Sent:* Thursday, July 28, 2011 06:16 PM
>
> *To:* excel-macros@googlegroups.com
> *Subjec
hange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Daniel
Sent: Thursday, July 28, 2011 06:16 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Reverse Vlookup
HI,
Try the below function ; the param
Objet : RE: $$Excel-Macros$$ Reverse Vlookup
Thanks XlS S, Venkat and other members, I have the solution for the query
but I thought it would be great to create the VBA Function which help as a
formula in excel.
So could you please help me with VBA code where we all could just type
something
Function
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Anil Bhange
Envoyé : jeudi 28 juillet 2011 14:23
À : excel-macros@googlegroups.com
Objet : RE: $$Excel-Macros$$ Reverse Vlookup
Thanks XlS S, Venkat and other members, I
t the result
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of XLS S
Sent: Thursday, July 28, 2011 05:44 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Reverse Vlookup
Try
Try this ..
please find the attachment
On Thu, Jul 28, 2011 at 5:05 PM, Venkat CV wrote:
>
> Hi Anil,
>
> Look Attached it will help u...
>
> *Best Regards,*
> *Venkat*
> *Chennai*
>
> On Thu, Jul 28, 2011 at 4:16 PM, Anil Bhange <
> anil.bha...@tatacommunications.com> wrote:
>
>> Hi
Use Sumproduct function ti will help you.
as manhy criteria you can put in brackets and get your desire result.
*SUMPRODUCT(($B$3:$B$21=E3)*$A$3:$A$21)*
On Thu, Jul 28, 2011 at 5:05 PM, Venkat CV wrote:
>
> Hi Anil,
>
> Look Attached it will help u...
>
> *Best Regards,*
> *Venkat*
> *Chennai*
>
Hi Anil,
Look Attached it will help u...
*Best Regards,*
*Venkat*
*Chennai*
On Thu, Jul 28, 2011 at 4:16 PM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:
> Hi All,
>
> ** **
>
> Could you help me with VB code for Reverse Vlookup function command where
> we can lookup value from
Hi All,
Could you help me with VB code for Reverse Vlookup function command where we
can lookup value from Right to Left.
Some similar to Vlookup but lookup from Right to Left.
Please give me a function code so that I can able to save this in Personal
workbook and use in all excel file.
Anil
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
=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
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
16 matches
Mail list logo