Perfect! Makes sense, thankyou very much. There is an area of this workbook where I require multiple arguments of this nature.

We have established the method for the day which I can't thank you enough for. However this one requires one cell to be 'Week One' and if the other cell says 'Monday' then call week ones Monday data.

I tried inserting another HLOOKUP function into the formula but it wouldn't work. Any ideas?