match and #ref
 

Hi,

Is there a way to go round the issue of data sort? The sorting of the sheet
is based on column B followed by C, then by A which is the lookup column. FYI
the formulae is as
follows;INDEX('UNIT-COG'!$E35:$G35,MATCH($A35,'UNIT-COG'!$A35:$A78),MATCH(SUMPRODUCT(MAX(('UNIT-COG'!$E$7:$G$7<=F$7)*'UNIT-COG'!$E35:$G35)),'UNIT-COG'!$E35:$G35,0))*Volumes!F35