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.

[TABLE="class: outer_border, width: 206"]
<tbody>[TR]
[TD="colspan: 2"]If[/TD]
[TD]Use[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]5000[/TD]
[TD]0.0195[/TD]
[/TR]
[TR]
[TD]5001[/TD]
[TD]10000[/TD]
[TD]0.0185[/TD]
[/TR]
[TR]
[TD]10001[/TD]
[TD]20000[/TD]
[TD]0.0175[/TD]
[/TR]
[TR]
[TD]20001[/TD]
[TD]30000[/TD]
[TD]0.0165[/TD]
[/TR]
[TR]
[TD]30001[/TD]
[TD]40000[/TD]
[TD]0.0155[/TD]
[/TR]
[TR]
[TD]40001[/TD]
[TD]and over[/TD]
[TD]0.0145[/TD]
[/TR]
</tbody>[/TABLE]

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.

[TABLE="class: cms_table_outer_border, width: 206"]
<tbody>[TR]
[TD]0[/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]5000[/TD]
[TD]0.0195[/TD]
[/TR]
[TR]
[TD]5001[/TD]
[TD]10000[/TD]
[TD]0.0185[/TD]
[/TR]
[TR]
[TD]10001[/TD]
[TD]20000[/TD]
[TD]0.0175[/TD]
[/TR]
[TR]
[TD]20001[/TD]
[TD]30000[/TD]
[TD]0.0165[/TD]
[/TR]
[TR]
[TD]30001[/TD]
[TD]40000[/TD]
[TD]0.0155[/TD]
[/TR]
[TR]
[TD]40001[/TD]
[TD]and over[/TD]
[TD]0.0145[/TD]
[/TR]
</tbody>[/TABLE]

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.