Hi all and thanks for looking at this page. I need some help!!

Basically, I have a spreadsheet where I need to enter the date automatically based upon what is in column A and column B.

So, column A is the week column (1-4) and column B is the day column (Sat-Fri). I have a grid hidden in the worksheet that shows the dates, based on what the user enters as the period start date (Saturday).

So, I need the cells in column C to do this (natural language):

If column A is equal to 1 and column B is equal to “Sat” then column C will equal the contents of the cell AB8. If column A is equal to 1 and column B is equal to “Sun” then column C will equal the contents of the cell AB9. etc etc etc

Anybody have any ideas as to how I would go about this. My brain has stopped working and I need some pointers.

Thanks.