Help with complex formula
 

Is it possible to write a formula that uses the input from cell H5 and
compares it to the various ranges of values in B6:C23 and if matched, returns
the value in column D to cell H6?

Data table:
A B C D E F G H
5 From To % Used Input: 2.16
6 $1.91 $1.95 15% % Used:
7 $1.96 $2.00 16%
8 $2.01 $2.05 17%
9 $2.06 $2.10 18%
10 $2.11 $2.15 19%
11 $2.16 $2.20 20%
12 $2.21 $2.25 21%
13 $2.26 $2.30 22%
14 $2.31 $2.35 23%
15 $2.36 $2.40 24%
16 $2.41 $2.45 25%
17 $2.46 $2.50 26%
18 $2.51 $2.55 27%
19 $2.56 $2.60 28%
20 $2.61 $2.65 29%
21 $2.66 $2.70 30%
22 $2.71 $2.75 31%
23 $2.76 $2.80 32%

TIA,
Steve Weaver

Help with complex formula
 

Hi Steve,

=VLOOKUP(H5,B6:D23,3)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Steve B" <Steve wrote in message
...
Is it possible to write a formula that uses the input from cell H5 and
compares it to the various ranges of values in B6:C23 and if matched,
returns
the value in column D to cell H6?

Data table:
A B C D E F G H
5 From To % Used Input: 2.16
6 $1.91 $1.95 15% % Used:
7 $1.96 $2.00 16%
8 $2.01 $2.05 17%
9 $2.06 $2.10 18%
10 $2.11 $2.15 19%
11 $2.16 $2.20 20%
12 $2.21 $2.25 21%
13 $2.26 $2.30 22%
14 $2.31 $2.35 23%
15 $2.36 $2.40 24%
16 $2.41 $2.45 25%
17 $2.46 $2.50 26%
18 $2.51 $2.55 27%
19 $2.56 $2.60 28%
20 $2.61 $2.65 29%
21 $2.66 $2.70 30%
22 $2.71 $2.75 31%
23 $2.76 $2.80 32%

TIA,
Steve Weaver

Help with complex formula
 

Thank you Niek, that did the trick.

"Niek Otten" wrote:

Hi Steve,

=VLOOKUP(H5,B6:D23,3)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Steve B" <Steve wrote in message
...
Is it possible to write a formula that uses the input from cell H5 and
compares it to the various ranges of values in B6:C23 and if matched,
returns
the value in column D to cell H6?

Data table:
A B C D E F G H
5 From To % Used Input: 2.16
6 $1.91 $1.95 15% % Used:
7 $1.96 $2.00 16%
8 $2.01 $2.05 17%
9 $2.06 $2.10 18%
10 $2.11 $2.15 19%
11 $2.16 $2.20 20%
12 $2.21 $2.25 21%
13 $2.26 $2.30 22%
14 $2.31 $2.35 23%
15 $2.36 $2.40 24%
16 $2.41 $2.45 25%
17 $2.46 $2.50 26%
18 $2.51 $2.55 27%
19 $2.56 $2.60 28%
20 $2.61 $2.65 29%
21 $2.66 $2.70 30%
22 $2.71 $2.75 31%
23 $2.76 $2.80 32%

TIA,
Steve Weaver