Hello
i have a table As Below
<tbody>
</tbody>
<tbody>
</tbody>
Cell value of B7 = 1800
Cell value of C7 = 7200
now i want to get Match value in Cell D7 like =Match(c7,b1:f6,0) answer will be 7210
if i change value of B7= 2000 then answer in Cell d7 will be 8460
So please help me ..
How can i find correct value...
please
i want to retrieve next closest higher value in table
as if i want to type value in cell b8 is
match(
i have a table As Below
B | C | D | E | F |
1800 | 1900 | 2000 | 2400 | 2800 |
7000 | 7730 | 8460 | 9910 | 11360 |
7210 | 7970 | 8720 | 10210 | 11700 |
7430 | 8210 | 8990 | 10520 | 12050 |
7660 | 8460 | 9260 | 10840 | 12420 |
7890 | 8720 | 9540 | 11170 | 12800 |
8130 | 8990 | 9830 | 11510 | 13190 |
<tbody>
</tbody>
<tbody>
</tbody>
Cell value of B7 = 1800
Cell value of C7 = 7200
now i want to get Match value in Cell D7 like =Match(c7,b1:f6,0) answer will be 7210
if i change value of B7= 2000 then answer in Cell d7 will be 8460
So please help me ..
How can i find correct value...
please
i want to retrieve next closest higher value in table
as if i want to type value in cell b8 is
match(