selecting a specific answer then export to a different sheet

Hi,

Based on the lowest value between cell L7 & L13 I need to export the associated data to the green cells in the office sheet. For this example I've highlighted the cells in orange that would need to be exported to the office sheet. If the block value in cell L7 was lower then I would need to export the corresponding data not the cells highlighted in orange. I hope this makes sense.

Thanks

Try the attached. Uses this formula to dscide which is the larger number, and copies the "winning" data across

=IF(Workings!$L$7>Workings!$L$13,Workings!B7,Workings!B13) - copied across to each relevant cell in the Office sheet

Doesn't work if both scores are equal, because I didn't look at how the workings are calculated. But if all the measures would be identical then change the formulae to "more than or equal to" as below.

=IF(Workings!$L$7>=Workings!$L$13,Workings!B7,Workings!B13)

Ochimus

perfect thank you!

Glad to help, and if it has solved the question, you need to close the query by clicking "Thread Tools" at the top and clicking "Solved".

And if you feel generous, a quick click on my reputation would not come amiss?

Ochimus