Problem with 64 levels of nesting

[marita]

Hello! I have two columns in the first sheet, one for the month and the other for the time (hourly time step). I also have a second sheet where water demand depends on the month and the hour, that means other demand for January at 1:00, other for January at 5:00, other for July at 17:00 etc. (12x24 table). So i want for each time step to for a whole year to check the month and the hour and to take the correct amount of water from the second sheet.
I used if-and (code example: =IF(AND(B8=1,E8=0), Data!G26,IF(AND(B8=1,E8=1), Data!G27,IF(AND(B8=1,E8=2), Data!G28,IF(AND(B8=1,E8=3)... etc.) where B is the month, E the time and Data the second sheet but if i do this for all the months (that means 288 if) i get the error "This formula can't be entered because it uses more than 64 levels of nesting"
Any ideas how can i overcome the problem and get my results, using maybe another excel function?

Thank you in advance!

 

[offthelip]

The way I would do that is with a "helper" column, in the helper column I would create a number which is 24 times the month number plus the hour. This will give you an unique number for each combination of month and hour. Then in your second sheet you can index/Match to pick the correct value, by multiplying the month by 24 and adding the hour

 

[jasonb75]

From your example, it looks like B8 refers to the column of the table and E8 refers to the row, if that is the case then something like

=INDEX(Data!$G$26:$$R$49,E8+1,B8)

Should do the trick (note that this involves guesswork on the full layout, it will most likely need some adjustments).

 

[marita]

wow! jasonb75 that easy? thank you very much. no adjustments needed! it worked!
offthelip thank you too for your time to answer my question!