Lookup values

[chris93]

Hello,

I have typed the following in Excel :

=LOOKUP("T",{"M","ta","u","v"})


why is Excel returning M , shouldn't it return "ta" , since "ta" is closest to T ?


=LOOKUP("T",{"X","ta","u","v"})


here Excel is giving me N/A. Shouldn't it return "ta" ?

 

[Marcelo Branco]

See
30 Excel Functions in 30 Days: 16

Take a look at the topic
LOOKUP Traps

M.

 

[Aladin Akyurek]

Hello,

I have typed the following in Excel :

=LOOKUP("T",{"M","ta","u","v"})


why is Excel returning M , shouldn't it return "ta" , since "ta" is closest to T ?

A variant of binary search algorithm leads to the last half consisting of the M cell and since M <= T, we get M.

=LOOKUP("T",{"X","ta","u","v"})


here Excel is giving me N/A. Shouldn't it return "ta" ?

Here the last half consisting of the X cell has a value that is not <= T (i.e., NOT X <= T). Hence #N/A.