subject:"$$Excel\-Macros$$ Reverse Vlookup"

$$Excel-Macros$$ Reverse Vlookup

2011-07-28 Thread Anil Bhange

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 Bhange

Business Planning & Management Reporting
Financial Planning & Analysis,

TATA Communications Ltd.
6th Floor, B Wing,
Bandra Kurla Complex, Bandra (East),
India



' Desk : + 91 22 6659 2320
| IP Phone : 51 2320 | Mobile :+ 91 90290 32123

anil.bha...@tatacommunications.com



-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Reverse Vlookup

2011-07-28 Thread Venkat CV

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 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 Bhange*
>
> *Business Planning & Management Reporting*
> Financial Planning & Analysis,
>
> TATA Communications Ltd.
> 6th Floor, B Wing,
> Bandra Kurla Complex, Bandra (East),
> India
>
> ** **
>
> ' Desk : + 91 22 6659 2320
> | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 
>
> anil.bha...@tatacommunications.com
>
> ** **
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Query-Reverse Vlookup by Venkat.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Reverse Vlookup

2011-07-28 Thread ICWAI Help

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*
>
>   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 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 Bhange*
>>
>> *Business Planning & Management Reporting*
>> Financial Planning & Analysis,
>>
>> TATA Communications Ltd.
>> 6th Floor, B Wing,
>> Bandra Kurla Complex, Bandra (East),
>> India
>>
>> ** **
>>
>> ' Desk : + 91 22 6659 2320
>> | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 
>>
>> anil.bha...@tatacommunications.com
>>
>> ** **
>>
>> ** **
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
>   *
> *
> *
> *
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Reverse Vlookup

2011-07-28 Thread XLS S

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 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 Bhange*
>>
>> *Business Planning & Management Reporting*
>> Financial Planning & Analysis,
>>
>> TATA Communications Ltd.
>> 6th Floor, B Wing,
>> Bandra Kurla Complex, Bandra (East),
>> India
>>
>> ** **
>>
>> ' Desk : + 91 22 6659 2320
>> | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 
>>
>> anil.bha...@tatacommunications.com
>>
>> ** **
>>
>> ** **
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *
> *
> *
> *
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


try.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

RE: $$Excel-Macros$$ Reverse Vlookup

2011-07-28 Thread Anil Bhange

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 like "=RLOOKUP() and will get 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 this ..

please find the attachment

On Thu, Jul 28, 2011 at 5:05 PM, Venkat CV 
mailto: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 
mailto: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 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 Bhange

Business Planning & Management Reporting
Financial Planning & Analysis,

TATA Communications Ltd.
6th Floor, B Wing,
Bandra Kurla Complex, Bandra (East),
India



' Desk : + 91 22 6659 2320
| IP Phone : 51 2320 | Mobile :+ 91 90290 32123

anil.bha...@tatacommunications.com<mailto:anil.bha...@tatacommunications.com>



--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.com<http://www.excel-macros.blogspot.com/>
4. Learn VBA Macros at 
http://www.quickvba.blogspot.com<http://www.quickvba.blogspot.com/>
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.com<http://exceldailytip.blogspot.com/>

To post to this group, send email to 
excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


--




--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel



--
.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ Reverse Vlookup

2011-07-28 Thread Daniel

HI,

Try the below function ; the parameters are the same as those of the VLOOKUP
function :

 

Function RLookup(ToSearch, rg As Range, col As Long, Optional ProxVal)

Dim RightRange As Range

If IsError(ProxVal) Then ProxVal = 1

Set RightRange = rg.Resize(, 1).Offset(, rg.Columns.Count - 1)

With Application

If ProxVal = 1 Then

RLookup = .Index(rg, .Match(ToSearch, RightRange, 1),
rg.Columns.Count - col + 1)

Else

RLookup = .Index(rg, .Match(ToSearch, RightRange, 0),
rg.Columns.Count - col + 1)

End If

End With

End 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 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 like “=RLOOKUP(……..) and will get 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 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
 wrote:

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 Bhange

Business Planning & Management Reporting
Financial Planning & Analysis,


TATA Communications Ltd.
6th Floor, B Wing,
Bandra Kurla Complex, Bandra (East),
India


 


' Desk : + 91 22 6659 2320 
| IP Phone : 51 2320 | Mobile :+ 91 90290 32123 


 <mailto:anil.bha...@tatacommunications.com>
anil.bha...@tatacommunications.com

 

 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
<http://www.excel-macros.blogspot.com/> 
4. Learn VBA Macros at http://www.quickvba.blogspot.com
<http://www.quickvba.blogspot.com/> 
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
<http://exceldailytip.blogspot.com/> 

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel





-- 

 

 

 

 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel




-- 
.

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
-

RE: $$Excel-Macros$$ Reverse Vlookup

2011-07-28 Thread Daniel

Just to precise that the « col » parameter should be a positive number, the
rightmost column being column 1.

 

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 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 like “=RLOOKUP(……..) and will get 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 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
 wrote:

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 Bhange

Business Planning & Management Reporting
Financial Planning & Analysis,


TATA Communications Ltd.
6th Floor, B Wing,
Bandra Kurla Complex, Bandra (East),
India


 


' Desk : + 91 22 6659 2320 
| IP Phone : 51 2320 | Mobile :+ 91 90290 32123 


 <mailto:anil.bha...@tatacommunications.com>
anil.bha...@tatacommunications.com

 

 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
<http://www.excel-macros.blogspot.com/> 
4. Learn VBA Macros at http://www.quickvba.blogspot.com
<http://www.quickvba.blogspot.com/> 
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
<http://exceldailytip.blogspot.com/> 

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel





-- 

 

 

 

 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel




-- 
.

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><>&l

RE: $$Excel-Macros$$ Reverse Vlookup

2011-07-28 Thread Anil Bhange

Thanks Daniel,

It's amazing and Finance people on this group will be grateful to you, just one 
more request to get this function inbuilt in excel, could you please share how 
and where to save the below macro.

Because I tried but not getting answer and it shows Error.

Regards,Anil 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
Subject: RE: $$Excel-Macros$$ Reverse Vlookup

HI,
Try the below function ; the parameters are the same as those of the VLOOKUP 
function :

Function RLookup(ToSearch, rg As Range, col As Long, Optional ProxVal)
Dim RightRange As Range
If IsError(ProxVal) Then ProxVal = 1
Set RightRange = rg.Resize(, 1).Offset(, rg.Columns.Count - 1)
With Application
If ProxVal = 1 Then
RLookup = .Index(rg, .Match(ToSearch, RightRange, 1), 
rg.Columns.Count - col + 1)
Else
RLookup = .Index(rg, .Match(ToSearch, RightRange, 0), 
rg.Columns.Count - col + 1)
End If
End With
End 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 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 like "=RLOOKUP() and will get the result

Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123

From: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> 
[mailto:excel-macros@googlegroups.com]<mailto:[mailto:excel-macros@googlegroups.com]>
 On Behalf Of XLS S
Sent: Thursday, July 28, 2011 05:44 PM
To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Subject: Re: $$Excel-Macros$$ Reverse Vlookup

Try this ..

please find the attachment
On Thu, Jul 28, 2011 at 5:05 PM, Venkat CV 
mailto: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 
mailto: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 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 Bhange

Business Planning & Management Reporting
Financial Planning & Analysis,

TATA Communications Ltd.
6th Floor, B Wing,
Bandra Kurla Complex, Bandra (East),
India



' Desk : + 91 22 6659 2320
| IP Phone : 51 2320 | Mobile :+ 91 90290 32123

anil.bha...@tatacommunications.com<mailto:anil.bha...@tatacommunications.com>



--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.com<http://www.excel-macros.blogspot.com/>
4. Learn VBA Macros at 
http://www.quickvba.blogspot.com<http://www.quickvba.blogspot.com/>
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.com<http://exceldailytip.blogspot.com/>

To post to this group, send email to 
excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


--




--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel



--
.
--
-

Re: $$Excel-Macros$$ Reverse Vlookup

2011-07-28 Thread XLS S

Hey,

Make Add-In

http://support.microsoft.com/kb/285337

http://www.ozgrid.com/VBA/excel-add-in-create.htm

On Thu, Jul 28, 2011 at 7:17 PM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:

> Thanks Daniel,
>
> ** **
>
> It’s amazing and Finance people on this group will be grateful to you, just
> one more request to get this function inbuilt in excel, could you please
> share how and where to save the below macro.
>
> ** **
>
> Because I tried but not getting answer and it shows Error.
>
> ** **
>
> Regards,Anil 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
> *Subject:* RE: $$Excel-Macros$$ Reverse Vlookup
>
> ** **
>
> HI,
>
> Try the below function ; the parameters are the same as those of the
> VLOOKUP function :
>
> ** **
>
> Function RLookup(ToSearch, rg As Range, col As Long, Optional ProxVal)
>
> Dim RightRange As Range
>
> If IsError(ProxVal) Then ProxVal = 1
>
> Set RightRange = rg.Resize(, 1).Offset(, rg.Columns.Count - 1)
>
> With Application
>
> If ProxVal = 1 Then
>
> RLookup = .Index(rg, .Match(ToSearch, RightRange, 1),
> rg.Columns.Count - col + 1)
>
> Else
>
> RLookup = .Index(rg, .Match(ToSearch, RightRange, 0),
> rg.Columns.Count - col + 1)
>
> End If
>
> End With
>
> End 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 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 like “=RLOOKUP(……..) and will get 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 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 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 Bhange*
>
> *Business Planning & Management Reporting*
> Financial Planning & Analysis,
>
> TATA Communications Ltd.
> 6th Floor, B Wing,
> Bandra Kurla Complex, Bandra (East),
> India
>
>  
>
> ' Desk : + 91 22 6659 2320
> | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 
>
> anil.bha...@tatacommunications.com
>
>  
>
>  
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><&g

RE: $$Excel-Macros$$ Reverse Vlookup

2011-07-28 Thread Rajan_Verma

You can Use LooKUP Function if Your data is Sorted

 

=LOOKUP(E3,$B$3:$B$21,$A$3:$A$21)

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Venkat CV
Sent: Thursday, July 28, 2011 5:06 PM
To: excel-macros@googlegroups.com
Cc: anil.bha...@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 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 Bhange

Business Planning & Management Reporting
Financial Planning & Analysis,


TATA Communications Ltd.
6th Floor, B Wing,
Bandra Kurla Complex, Bandra (East),
India


 


' Desk : + 91 22 6659 2320 
| IP Phone : 51 2320 | Mobile :+ 91 90290 32123 


 <mailto:anil.bha...@tatacommunications.com>
anil.bha...@tatacommunications.com

 

 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
<http://www.excel-macros.blogspot.com/> 
4. Learn VBA Macros at http://www.quickvba.blogspot.com
<http://www.quickvba.blogspot.com/> 
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
<http://exceldailytip.blogspot.com/> 

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel




-- 

 

 

 

 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


ReverVlookup.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Reverse Vlookup

2011-07-28 Thread Mahesh parab

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 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 Bhange*
>
> *Business Planning & Management Reporting*
> Financial Planning & Analysis,
>
> TATA Communications Ltd.
> 6th Floor, B Wing,
> Bandra Kurla Complex, Bandra (East),
> India
>
> ** **
>
> ' Desk : + 91 22 6659 2320
> | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 
>
> anil.bha...@tatacommunications.com
>
> ** **
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Vlookup_R.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Reverse Vlookup

2011-07-28 Thread Haseeb Avarakkan

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 usually works.

Or, as the experts shows you can use, INDEX/MATCH, OFFSET, LOOKUP

See the attached.

HTH
Haseeb

For tips visit;
http://www.excelfox.com/forum/forum

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


RVLOOKUP.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Reverse Vlookup

2011-07-28 Thread XLS S

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,
>
> =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 usually works.
>
> Or, as the experts shows you can use, INDEX/MATCH, OFFSET, LOOKUP
>
> See the attached.
>
> HTH
> Haseeb
>
> For tips visit;
> http://www.excelfox.com/forum/forum
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Reverse Vlookup - -- very very urgent

2011-06-09 Thread hanumant shinde

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 modifying anything. i.e something 
like =VLOOKUP(E2,$B$2:$D$8,3,0) but this will not work as in a range parameter 
No. column is not at 1st place.

please find the attached workbook for more details.
let me know if you need anything else.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Reverse Vlookup.xls
Description: application/excel

Re: $$Excel-Macros$$ Reverse Vlookup - -- very very urgent

2011-06-09 Thread STDEV(i)

=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
> 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 modifying anything. i.e
> something
> like =VLOOKUP(E2,$B$2:$D$8,3,0) but this will not work as in a range
> parameter
> No. column is not at 1st place.
>
> please find the attached workbook for more details.
> let me know if you need anything else.
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


ctv_Vlookup_to_LEFT.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Reverse Vlookup - -- very very urgent

2011-06-09 Thread kannan excel

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 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 modifying anything. i.e
>> something
>> like =VLOOKUP(E2,$B$2:$D$8,3,0) but this will not work as in a range
>> parameter
>> No. column is not at 1st place.
>>
>> please find the attached workbook for more details.
>> let me know if you need anything else.
>>
>> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Reverse Vlookup

Re: $$Excel-Macros$$ Reverse Vlookup

Re: $$Excel-Macros$$ Reverse Vlookup

Re: $$Excel-Macros$$ Reverse Vlookup

RE: $$Excel-Macros$$ Reverse Vlookup

RE: $$Excel-Macros$$ Reverse Vlookup

RE: $$Excel-Macros$$ Reverse Vlookup

RE: $$Excel-Macros$$ Reverse Vlookup

Re: $$Excel-Macros$$ Reverse Vlookup

RE: $$Excel-Macros$$ Reverse Vlookup

Re: $$Excel-Macros$$ Reverse Vlookup

Re: $$Excel-Macros$$ Reverse Vlookup

Re: $$Excel-Macros$$ Reverse Vlookup

$$Excel-Macros$$ Reverse Vlookup - -- very very urgent

Re: $$Excel-Macros$$ Reverse Vlookup - -- very very urgent

Re: $$Excel-Macros$$ Reverse Vlookup - -- very very urgent

16 matches

Site Navigation

Mail list logo

Footer information