Hello
I'm trying to put order to some raw data but I've hit a wall with VLOOKUP. I've attached some example data with a desired outcome but some help with the formula to achieve this would be greatly appreciated.
Basically, in N3:Q10 I'm trying to find a formula to lookup the corresponding reference in column M within the raw data (A2:K10) taking into consideration the corresponding date in row 2. For example, Q9 would return the value in K6 (PRW01 on 03/08/20).
I think I need the nested INDEX & MATCH functions but I just can't get it to work.
Thanks
Demesne
Bookmarks