Hi All,
I was hoping someone wouldn't mind taking a quick look at the attached file.
Goal: Formulas in E3 and F3 copied down.
I thought I would be able to come up with individual formulas, such as, with the help of this forum, extracting values in L to N into F6 to F8 by using the following formula
=INDEX(INDEX($L$3:$N$14, MATCH(INDEX($B$3:$B$26, MATCH($E$3,$A$3:$A$26,0)),$K$3:$K$14,0),),AGGREGATE(15,6,COLUMN($L$2:$N$2)-COLUMN($L$2)+1/($L$2:$N$2<>""),ROWS(F$6:F6)))
..and sorting out how to retrieve other values myself, for example in F3
=IF(E3<>"",INDEX($B$3:$B$26,MATCH(E3,$A$3:$A$26,0)), "")
...and using COUNTA to get values for Column E, then combining all of the above, and figuring out what to adjust and how they can be copied down, to achieve the desired results.
But I am having a bit of trouble retrieving values in H.
And so far the formula in F6:F8 only works because it uses an absolute reference $E$3 for its lookup value.
Am I close with my attempts?
I appreciate the help.
Bookmarks