Hi,
I am trying to create a formula that will match two pieces of information I want to lookup a value based on a date and the pattern that they are on for a rota.
I was thinking something on the lines ofin the first cell then dragging it down for the rest but I cant get it to work:Please Login or Register to view this content.
I have attached a file so you can see what I am attempting to do. Any assistance appreciated.
test9.xlsx
Regards
John
Bookmarks