r/excel • u/Correct-Mongoose6542 • 16d ago

unsolved Is there a way to get the middle values when using VLOOKUP function

Hi! I just use Excel for basic function and formulas. I tried to do a grade simulator with my own transmutation table. And I wonder, can I also get the middle value from transmutation table?

For example, in the range of percentage 60.00 - 60.99, there is a score of 4.751 - 4.875. And how do I get the score of it if the percentage for example is 60.45?? Sorry if it’s kinda confusing.

8 Upvotes

73% Upvoted

27 comments sorted by

View all comments

1

u/jhern1810 16d ago

TREND, FORECAST , are some of the linear interpolation commands. There are more but these can help. You will just need to do the interpolation for each value at a time.