$$Excel-Macros$$ Re: Vlookup not working in 2007

2009-08-28 Thread Sathish Jalendran
Hi,

 

Check the attached file 

1 u have to freeze cells in the formula 

2 you have to convert to numbers before applying the formula

 

Regards

Sathish Jalendran

 

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Mahesh
Sent: 28 August 2009 PM 12:08
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlookup not working in 2007

 

Dear Friends,

 

I m facing this problem in Excel 2007.

 

attached is the excel sheet, kindly help.



-- 
With Love,
Mahesh Bisht



The information contained in this electronic message and any attachments to 
this message are intended for the exclusive 
use of the addressee(s) and may contain proprietary, confidential or privileged 
information. If you are not the intended
 recipient, you should not disseminate, distribute or copy this e-mail. Please 
notify the sender immediately and destroy
 all copies of this message and any attachments contained in it.


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Copy of Test.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


$$Excel-Macros$$ Re: Vlookup not working in 2007

2009-08-28 Thread Mahesh
thanx

On Fri, Aug 28, 2009 at 2:20 PM, Sandeep  wrote:

>  Hi Mahesh,
> Find the attached solution
>
> Regards
> Sandeep
>
>  - Original Message -
> *From:* Mahesh 
> *To:* excel-macros@googlegroups.com
>  *Sent:* Friday, August 28, 2009 12:07 PM
> *Subject:* $$Excel-Macros$$ Vlookup not working in 2007
>
>   Dear Friends,
>
> I m facing this problem in Excel 2007.
>
> attached is the excel sheet, kindly help.
>
> --
> With Love,
> Mahesh Bisht
>
> >
>


-- 
With Love,
Mahesh Bisht

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---