weird problem with LOOKUP function

  • Thread starter Thread starter ab
  • Start date Start date
A

ab

Hi,

This is my spreadsheet. Column C has the LOOKUP formula.

A B C
53 a a LOOKUP(A2,$A$2:$A$14,$B$2:$B$14)
447 b b LOOKUP(A3,$A$2:$A$14,$B$2:$B$14)
1 020 c c |
1 906 d n |
2 007 e n |
1 876 f n |
1 707 g g |
1 549 h c |
1 411 i c |
1 292 j c |
1 190 k c |
1 102 m c |
1 026 n c |

The values in column C are supposed to be just the same as column B, but
they are not. There is something hidden going on here which i cannot
understand. I would appreciate any help.

Thanks.
 
Read Help for LOOKUP. The LOOKUP function assumes that column A is
sorted in ascending order, which is not true in your case. If you use
VLOOKUP, there is an optional final argument that can be used to request
exact matches with unsorted data.

Jerry
 
Back
Top