I think I need to nest an aggregate within an index match function? Not a clue where how to make that happen
Worksheet attached.
On the Medical Add Change Tab - Column D is where the formula needs to go
Column A i have highlighted "duplicate instances"
Within Column D I need to pull in the respective value from Output Tab, Column M.
My index match (deleted) is only pulling the initial instance, (basically the same formula from Colum C, INDEX(Output!$M:$M,MATCH(1,INDEX(($A2=Output!$B:$B)*($T$1=Output!$A:$A),0,1),0))
How would I nest in an aggregate (I assume this is what I need) to pull the subsequent instances for each repeated value in A?
Bookmarks