Home |
Search |
Today's Posts |
#1
|
|||
|
|||
weird problem with LOOKUP function
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
weird problem with LOOKUP function | Excel Discussion (Misc queries) | |||
VBA Custom function for lookup | Excel Worksheet Functions | |||
Odd problem with LOOKUP | Excel Discussion (Misc queries) | |||
Lookup function help | Excel Worksheet Functions | |||
Lookup Function help | Excel Discussion (Misc queries) |