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
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
14 matches
Mail list logo
