VLOOKUP not returning correct results 1

[Fr33dan]

I'm creating a spreadsheet that need to take values from Column A lookup the closest value in Column AA and place the corresponding value in column AB into column B. All the data begins on row 15.

AA    |AB
869.18|-200.43
670.37|-88.8
353.19|-14.7
0     |-5.5

When I put =VLOOKUP(A15,$AA$15:$AB$54,2,TRUE) into B15 it returns -5.5 but A15 = 869.18 so it should return -200.43.

 

[Zathras]

When the fourth parameter is TRUE, the table must be sorted in ascending order (Column AA in this case).

If you sort your data correctly, you should see the correct result.

 

[Fr33dan]

Awesome that did the trick. Thanks