Thanks to this fantastic webiste, I've saved a lot of time by doing two-way lookups with an index and two match fuctions formula
=INDEX($A:$D,MATCH($F3,$A:$A,0),MATCH(G$2,$A$1:$D$1,0))
I was wondering if there is a way to take this one step further.
For the first match funciton...