Originally Posted by
belinda200
Maybe something like that?
In column A:
=IFERROR(INDEX('extracted from Database'!$A$1:$A$15,AGGREGATE(15,6,(ROW('Final Report'!$A$2:$A$15)/(MATCH('extracted from Database'!$A$2:$A$15,'extracted from Database'!$A$2:$A$15,0)=ROW('extracted from Database'!$A$1:$A$15))),ROWS($J$1:J1))),"")
In P and drag to Q:
=INDEX('extracted from Database'!K$1:K$15,AGGREGATE(15,6,(ROW('extracted from Database'!$A$2:$A$15))/('Final Report'!$A2='extracted from Database'!$A$2:$A$15),1))
In R and drag to S:
=INDEX('extracted from Database'!K$1:K$15,AGGREGATE(14,6,(ROW('extracted from Database'!$A$2:$A$15))/('Final Report'!$A2='extracted from Database'!$A$2:$A$15),1))
Bookmarks