VLookup with 2 values

[Lynsvyr]

Right now I have an If statement which works great when I am running a specific location. However I was hoping to instead utilize a Vlookup to review tables

Currently this is my formula:
=IF(B8="Night 10 Hour","18:00",IF(B8="Day 10 Hour","07:00",IF(B8="BHN/RT","18:00")))

What I would like to do is have another worksheet with the times instead, then when I select my Location (ABQ1) and the Shift that is running (Night 10 Hour) return the value for the correct time.

For example if I select ABQ1 & Night 10 Hour then it would return the value in the other worksheet E3 (18:00) and place that in the first worksheet on C9.
or
If I select BOI2 & Day 10 Hour then it would return the value from the other worksheet C9 (7:00) and place that in the first worksheet on C9.

 

[Rijnsent]

Building this up in steps:

• MATCH for the location: =MATCH("BOI2",'SHEETNAME'!A:A,0) -> should return the row where the data for that location starts (
• MATCH for the hours: =MATCH("Days start",'SHEETNAME'!2:2,0) , assuming your headers (row 2 of your screenshot) are the same for every location, it should return the right column
• after that you can take e.g. an INDEX function or an OFFSET function (from the MATCHes you'd need to do a -1 if you start from A1) to get to your value

Good luck,
Koen