Fun problem-solving in Excel with INDEX MATCH to Drag across columns. @JoelSperanza https://www.youtube.com/channel/UC9A1Elwl0rBUnI5n_7qKHuA was posting on twitter about the joy of formulae just working in Excel first time, not me. I love it when I finally nail something that's been bugging me for a while. This one sure had been.
I was trying to build a dynamic dashboard and I couldn't quite get it to create one of the lines of information without retyping in the column number for either the INDEX MATCH/VLOOKUP for each column - which was obviously leading to human error.
Fun little hack worked it out in the end.