Populate a cell using 2 reference points
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.
|