Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|