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,
Bookmarks