• 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.

Lookup and Get value for a range

K

kiran5

New Member
Hi,

Need your valuable answer for this:

I have A column with some index numbers and subsequently B, C, D & E column with some numbers as below:


0.0234 - 0.0238 0.12 x 0.651 2
0.0239 - 0.0249 0.134 y 1.25 3
0.0250 - 0.1468 0.524 z 1.265 5
0.1469 - 0.2554 0.513 a 1.365 4
0.2554 - 5.5648 0.654 b 1.555 6


If I input a number in H1 as 0.0248 then it should check where does this 0.0248 lies in the range of A column and give output for that range in H2 as 0.134 (in the same row of the range of B column value) & H3 as 0.125 (in the same row of the range of D column value) and H4 as 3 (in the same row of the range of E column value)


Please suggest.

Rgds,
Kiran
 
Hi,
My A column has a range of values like below:
0.0234 - 0.0238
0.0239 - 0.0249
0.0250 - 0.1468
0.1469 - 0.2554
0.2554 - 5.5648
B column as:
0.12
0.134
0.524
0.513
0.654

I will have a range of numbers in A column rather the exact numbers to identify. Please check
 
You must log in or register to reply here.
Back
Top