excel - Return a cell value/reference -
i have sheet automatically calculates ratio based on couple inputs, ratio corresponds listed rate. add formula cell automatically populates rate based on ratio rather having manually match , enter it.
for example want formula in cell d25 , if d24 equals value of g20, d25 display value of cell i20. if d24 equals value of g21, d25 display value of cell i21, , on total of 10 different rates/ratios. there formulas this? have tried few , looked around , can't seem find 1 works. preferably being able use cell references if ratio/rate changes can adjusted more having adjust actual formula.
you need vlookup:
=vlookup (d24, g20:i29, 3, false)
Comments
Post a Comment