I am currently trying to work out a formula with no success, i have been using multiple IF,IFS,MATCH and ROUNDS.

Scenario:
I HAVE;

Using 5 different points of criteria on SHEET 1 I have created 12 cells that can each have 16 different codes. 192 possibilities E.G "jan_under_n_s_n" or "jul_over_y_n_y"
(This code will tell me which table i need to draw information from)

I NEED;

a formula that uses that Code and a number from a cell in Sheet 2 (the number needs to be rounded up to the nearest 5)
and match it to column A from the necessary table and results in the cell from column B being the result.


hope this makes sense. i find it hard to explain.

Thanks,