Okay, I’m looking for a formula. I’ve got a sheet with headings along row 2, and weeks down column A (from A3 downwards). So a pretty simple setup, A, B, C etc along the top, 1, 2, 3, etc down the side.
I want to find the value that matches both the week and the heading from another sheet, so in B3 I want to look for a value that matches Heading B and Week 1, and so on. In this other sheet which already contains the values the week numbers are in column A and the headings are down column B, with the values I want in column c.
It’s something I feel like must be fairly simple, but I’m trying IF functions and VLOOKUPs and not quite getting there.