Sumproduct I think but a tough one
Thx alot
"barry houdini" wrote:
Are B10:B129 all different? If so you could use
=INDEX('Source'!D$10:Q$129,MATCH(J1,'Source'!B$10: B$129,0),MATCH(B
$3,'Source'!D$8:Q$8,0))
regards, barry
or if there might be multiple matches in column B
=SUMIF('Source'!B$10:B$129,J1,INDEX('Source'!D$10: Q$129,0,MATCH(B
$3,'Source'!D$8:Q$8,0)))
regards, barry
.
|