Forum Discussion
Excel help
Hello Excel experts I need some help, been pluging around on google for hours and while got it close to work, can't get this nailed down. See attached file For column A:B, I am looking to input a ...
In F2, you may use this formula, copied down rows and across columns:
=INDEX($B:$B,
MATCH($E2,$B:$B,0)+
MATCH(F$1,$A$3:$A$6,0))
=INDEX($B:$B,
MATCH($E2,$B:$B,0)+
MATCH(F$1,$A$3:$A$6,0))
