• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How To find 2nd higher lookup value

tiong999

Member
Hello everyone,

I would like to ask if i need to find 2'th higher lookup value.

Please take a review within my illlustration attached file.

Thanks for any contribution, im appreciated so much.

Regards,
Tiong
 

Attachments

  • 2nd higher lookup value.xlsx
    8.5 KB · Views: 8
Hello everyone,

I would like to ask if i need to find 2'th higher lookup value.

Please take a review within my illlustration attached file.

Thanks for any contribution, im appreciated so much.

Regards,
Tiong
Hello Tiong,
Please use this formula in D7.
=INDEX(B4:Q4,MATCH(D6,B4:Q4)+(LOOKUP(D6,B4:Q4)<>D6))
 
Hi ,

It is not really clear from the data what you mean.

The values higher than 4.5 are 4.55 , 5.48 , 5.54 ,...

Why did you choose 5.54 ?

Suppose the lookup value was 8.31 ; what would be the result ?

Suppose the lookup value was 8.32 ; what would be the result ?

Explain your logic clearly and thoroughly , so that we do not have to assume anything.

Narayan
 
Hi ,

It is not really clear from the data what you mean.

The values higher than 4.5 are 4.55 , 5.48 , 5.54 ,...

Why did you choose 5.54 ?

Suppose the lookup value was 8.31 ; what would be the result ?

Suppose the lookup value was 8.32 ; what would be the result ?

Explain your logic clearly and thoroughly , so that we do not have to assume anything.

Narayan

Hello Narayan,

Yes, its my bad to explained it not clearly.

So, the 2nd larger than lookup value, should be 5,48 after 4,55.

Regards,
Tiong
 
Last edited:
Back
Top