Assistance populating cell with number from chart

[hipmrc]

I am re-posting this question in order to try to make it more clear. (I could not figure out how to delete my prior post if that is possible)

Not sure if I phrased the title correctly, but I am trying to populate a cell in my workbook with a number from the last column in the chart below.

So, based on the number in H24 I need the correct corresponding number from the "Use" column to populate. Example if H24 is 25,000 I need .0165 to populate into G28.

If	Use
0		0
1	5000	0.0195
5001	10000	0.0185
10001	20000	0.0175
20001	30000	0.0165
30001	40000	0.0155
40001	and over	0.0145

<tbody>
</tbody>

Right now the chart is on another page of the workbook and whited out so that it does not show. Please let me know if you need any clarification - and THANK YOU in advance for the assistance with this.

 

[Legacy 396030]

Try this for the exact values or replace the numbers with cells:

=IF(H24=25000,.0165,"")

 

[hipmrc]

When I tried that I got an error. The cell with the formula was blank and then the rest of the cells that calculated from that cell went to #Value! error.

I need the answer to come from a range in the chart.

if 0 then answer is 0
if between 1 and 5000 answer is 0.0195
if between 5001 and 10000 the answer is 0.0185
etc.

0		0
1	5000	0.0195
5001	10000	0.0185
10001	20000	0.0175
20001	30000	0.0165
30001	40000	0.0155
40001	and over	0.0145

<tbody>
</tbody>

Please let me know if I can provide any additional information to further clarify, and thank you in advance for your assistance
Michael

 

[63falcondude]

Try =LOOKUP(H24,A1:A7,C1:C7) with the lookup table in A1:C7

or

=LOOKUP(H24,{0,1,5001,10001,20001,30001,40001},{0,0.0195,0.0185,0.0175,0.0165,0.0155,0.0145}) with no lookup table.

 

[hipmrc]

I used the second one since I've never worked with a look up table and it worked PERFECTLY!!! Thank you so much! You just made my day.

 

[63falcondude]

I used the second one since I've never worked with a look up table and it worked PERFECTLY!!! Thank you so much! You just made my day.

Great! Glad to help. A lookup table is what you showed in post #3.
For that first formula to work, you would have to include that table somewhere on the worksheet.

I generally prefer hard-coding the values into the formula so that you do not have to include a table in the worksheet.