Thanks:  0
Likes:  0

# Thread: Lookup values

1. ## Lookup values

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" ?

2. ## Re: Lookup values

See
30 Excel Functions in 30 Days: 16

Take a look at the topic
LOOKUP Traps

M.

3. ## Re: Lookup values

Originally Posted by 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 ?
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.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•