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.
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 Right
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 venkat1@gmail.com wrote:
Hi Anil,
Look Attached it will help u...
*Best Regards,*
Try this ..
please find the attachment
On Thu, Jul 28, 2011 at 5:05 PM, Venkat CV venkat1@gmail.com 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:
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
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
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
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 parameters
** **
*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 parameters
...@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
anil.bha...@tatacommunications.com wrote:
Hi All,
Could you help me with VB code for Reverse Vlookup function
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 from Right
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
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,
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:
16 matches
Mail list logo