I am trying to have a cell with a specific value lookup a value if the conditions are true. Ill try to explain the best i can.
In my attached spreadsheet i have tabs DT Dept.20, Scrap Dept. 20 and Dept 20 (3099). In the tab named Dept 20 (3099) under C12:C22 and C26:C36 there are blanks to enter down time hours that are located in tab DT Dept. 20. So to get the value for cell C12 in the Dept. 20 (3099) tab i am trying to get it to see if the following values are true for it and insert the corresponding value. To be true it would have to look at the following in the DT Dept. 20 tab. The resource would have to be (3099), the shift would have to be (1) and the code would have to be AC. If all of those were true it would see that the corresponding value was (1.8) and insert the value into Dept. 20 (3099) C12.

Im not sure if this can be done with a function or if i would have to get into VB but let me know if you have any advice of questions on it.

Thank you in advance

Test.xlsx