Hello Tiong,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
=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 ,Hello Narayan,
Yes, its my bad to explained it not clearly.
So, the 2nd larger than lookup value, should be 5,54 after 4,55.
Regards,
Tiong
My Bad, dont know why i keep mistyping.Hi ,
Why not 5.48 ?
Narayan
Hello,Hi ,
See your file.
Narayan