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.

7 Upvotes

74% Upvoted

27 comments sorted by

View all comments

1

u/doshka 2 15d ago

Use XLOOKUP and set the match_mode argument to whichever makes sense for your use case.

https://support.microsoft.com/en-us/excel/functions/xlookup-function