Hi, I hope someone can give a little advice please.



What i am trying to attempt is to create a spreadsheet of a works rota that can populate a table of all employees off days within a calendar year. I am struggling to find a solution that enables me to populate a cell from a reference table using 2 reference points (a week and a day). The reference table has 3 columns. "week row", "day Number" and "job".

I have tried using vlookup to locate a cell in the "job" column but it doesn't work. How can i use a formula to first lookup a week (say week 3) and then in week 3 lookup any given day, lets say day 5 (which represents Thursday) and return a value of "403"?

Thanks in advance. It wouldn't surprise me if its a simple solution.

Attached Files

example 1.xlsx (8.6 KB, 10 views)