I am currently working with vlookup and getting some very strange results in Excel 2003.
The bottom row is a a vlookup to find information from a particular month listed above. This is eventually going to be built into a larger formula to show percentage change between 2 months.
The formula I am using in B6 is =vlookup($A$5,$A$2:$G$4,2)
the 2 is changed to 3 and so on for the appropriate columns
As you can see when I use the value of Jan 10 I have all 0's returned. If I chnage Jan 10 in F1 to Dec 09 or Feb 10 I get the values for the appropriate rows.
To add to the confusion If I change Jan 10 in the table and the lookup value to Jan or January it still does not work. I then tried a few random values in there and found the following. Der 10, duncan and egg work while book, march, josh and try do not.
The cells in column A are all set to Text.
The only changes I am making for my tests were substituting the values in column A. I also tried copying Jan 10 and using paste value but this produced the same results.
Any ideas?
The bottom row is a a vlookup to find information from a particular month listed above. This is eventually going to be built into a larger formula to show percentage change between 2 months.
The formula I am using in B6 is =vlookup($A$5,$A$2:$G$4,2)
the 2 is changed to 3 and so on for the appropriate columns
As you can see when I use the value of Jan 10 I have all 0's returned. If I chnage Jan 10 in F1 to Dec 09 or Feb 10 I get the values for the appropriate rows.
To add to the confusion If I change Jan 10 in the table and the lookup value to Jan or January it still does not work. I then tried a few random values in there and found the following. Der 10, duncan and egg work while book, march, josh and try do not.
The cells in column A are all set to Text.
The only changes I am making for my tests were substituting the values in column A. I also tried copying Jan 10 and using paste value but this produced the same results.
Any ideas?