selecting a specific answer based on two conditions then export to a different sheet

[CPAC]

Hi,

I basically want to export the information from the workings sheet to the office sheet based on the lowest volume highlighted in red, then the highest number in the orange cell if the volumes are equal.

I've highlighted the values in green (+volume highlighted in red) that I want to export to the working sheet for this example. As you can see it's currently importing the wrong set of data based on this example.

I hope this makes sense.

Thank you

[6StringJazzer]

I don't understand the criteria you are using to export the values. You say "the lowest volume" but there is only one volume. Will your workings sheet normally have a list of values, instead of just one? It would help to show a realistic mock-up of your data with a more detailed walkthrough of which cells you are working with.

[CPAC]

Hi,

If you change the values highlighted in orange on the office sheet the values on the workings sheet change accordingly. eg 700 X 200 X 10MM This example shows two different volumes I require the information associated with the lowest volume between cells L7 & L13 if these volumes are equal (as per the original example) then I need to select information associated with the highest value between cells D7 & D13.

I need to move the correct information across to the office sheet.

Thanks,