View original (French)

Excel VLOOKUP returns incorrect value

Solved
cavujo Posted messages 68 Status Membre -  
 Merci -
Hello,
First of all, I wasn't quite sure which topic to place my question in...
I have a problem with the VLOOKUP function in Excel. Do you know why it returns the last value of my table?

I have a table with dates in one column (C), and sales figures in the second column (D).
I'm giving it a date in cell A1, and I want it to return the associated sales figure. The formula is therefore:

=VLOOKUP(A1,C:D,2)

but it returns the last value of the table..

The dates are in numeric format in Excel. I've also tried bounding the columns in the lookup, for example: C1:D102; but that doesn't work either...

Thank you
Configuration: Windows XP Firefox 3.5.5

3 réponses

Réponse 1 / 3
verlion
 
try using: =VLOOKUP(A1,C:D,2,FALSE) otherwise, it will look for an approximate value and it might be the last one. With FALSE, it looks for the exact value.

Otherwise, it might be due to the cell format of the date column (is it in date format?)
good luck
32
jimmy1120112 Posted messages 713 Status Membre 61
 
Thank you Verlion!!

The search function was giving me wrong results, with the simple "FALSE" it fixed everything...
0
jackselere
 
super thanks a little mistake solves my super big problem
0