Index match formula from sales data worksheet to receivable worksheet

Please try at
B9
=IF(C9="","",INDEX('SALES DATA'!$B$4:$B$99,MATCH(C9,'SALES DATA'!$G$4:$G$99,)))

C9
=IFERROR(AGGREGATE(15,6,'SALES DATA'!$G$4:$G$99/('SALES DATA'!$D$4:$D$99=$B$8)/('SALES DATA'!$G$4:$G$99>MAX(C$8:C8)),1),"")

D9
=IF(C9="","",VLOOKUP(C9,'SALES DATA'!$G$4:$S$99,13,))

E9
=IF(C9="","",SUMIFS('SALES DATA'!$R$4:$R$99,'SALES DATA'!$G$4:$G$99,C9))