multiple criteria from one sheet to draw information from the correct table on another

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,

Attach a workbook with enough sample data to show what you are trying to achieve.

Go Advanced -> manage Attachments -> Upload

see below for picture

thanks for the clarification.

Originally Posted by Jonesey-16

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.

I don't see Sheet 2 in your attachment.

Your instructions need to reflect exactly what your sample shows.

ahh sorry, I put it under the code on sheet three on that sample. I need cells B8 (the code) and B9 (the number that would usually be on another sheet) to get the result from the table.

How does the "under_n_s_n" part of the code effect the selection?

It seems to only need "jan" and the weight to make a choice.

they will reference me to one of 8 tables, as in if it was "dec_y_s_n" It would be for e.g table 6, but if it was "dec_y_n_n" it would be table 1

breakdown is "Month_Days over and under 10_Yes/No_north/south_Yes/No"