Return a cell value/reference

Question

I have a sheet which automatically calculates a ratio based on a couple inputs, this ratio then corresponds to a listed rate. What I would like to do is add a formula to a cell so that it automatically populates a rate based on a ratio rather than having to manually match it up and enter it.

For example I want the formula to be in cell D25 and if D24 equals the value of G20, I would like D25 to then display the value of cell I20. If D24 equals the value of G21, I would like D25 to display the value of cell I21, and so on with a total of 10 different rates/ratios. Is there any formulas to do something like this? I have tried a few and looked around and can't seem to find one that works. Preferably being able to use cell references so that if the ratio/rate changes it can be adjusted more easily than having to adjust the actual formula.

Answer 1

You need VLookup:

=VLookup (D24, G20:I29, 3, False)