Hi,
I have back data that will renew every month with different accounts and zones. They will have a 'result' every month. I want to match the zone and account for the relevant month and populate the result in a matrix - see attached sheet named front. It needs to pull this from the back data sheet.
I tried using index and match but couldn't figure it out, any suggestions?
Bookmarks