If cell contains (certain numerical value) then return (corresponding numerical value)

[MidwestDrummer]

Below is a screen shot of my RMD calulator that I use frequently at work. I would like to be able to key in a person's age in B3, and then have the corresponding RMD factor automatically populate in B4. For example, if I key in "74" into B3, I would like to have "23.8" automatically populate in B4. I attempting the following:

=LOOKUP(B3, {"70","71","72"}, {"27.4","26.5","25.6"})

However, as you can see in the screen shot, I'm not having any luck. I've found that if I replace the numerical ages with words (such as vegetables and also replace the numerical RMD factors with words (such as each vegetables corresponding color), then the formula works. However, when I replace the words with numbers, that seems to break it. Any idea how I might go about this?

 

[Joe4]

Welcome to the Board!

Note that double-quotes indicates Text. If you are dealing with numbers, get rid of them, i.e.

=LOOKUP(B3, {70,71,72}, {27.4,26.5,25.6})

 

[MidwestDrummer]

Welcome to the Board!

Note that double-quotes indicates Text. If you are dealing with numbers, get rid of them, i.e.

=LOOKUP(B3, {70,71,72}, {27.4,26.5,25.6})

Thank you very much!

 

[Joe4]

You are welcome!

If you have a large list, you may want to also consider setting up a lookup table and using a VLOOKUP formula.
One advantage to that is if you ever need to add or change values, you only have to do it in one place, and do not need to update all your formulas.

 

[MidwestDrummer]

You are welcome!

If you have a large list, you may want to also consider setting up a lookup table and using a VLOOKUP formula.
One advantage to that is if you ever need to add or change values, you only have to do it in one place, and do not need to update all your formulas.

I added my list to the Excel file. What formula would be to most efficient for keying in the age into B3, and having the agent automatically populate in B4 from the list in the bottom portion of my screen shot?

 

[Joe4]

As to which one is most "efficient" (lookup, vlookup, index/match), I really cannot say. However, I find that vlookup is the easiest to use and maintain, especially if you name the lookup range and use that named range in your function.
See: https://www.myexcelonline.com/blog/excel-named-ranges-with-vlookup-formula-excel/

 

[MidwestDrummer]

As to which one is most "efficient" (lookup, vlookup, index/match), I really cannot say. However, I find that vlookup is the easiest to use and maintain, especially if you name the lookup range and use that named range in your function.
See: https://www.myexcelonline.com/blog/excel-named-ranges-with-vlookup-formula-excel/

Thanks again. I'll give that a try when I've got some free time.