compare name in one sheet with sheet and transfer entries

[gilnic]

Hello,
I have a query which I hope someone can assist me with please.
In my sheet 'gruss' I have an entry in AA6 – Forjo.
I would like to be able to find this entry in my sheet named 'threes'.
I wish to know if it is not in the top two names in Col C under 'horse'. If this is the case I would like to have the top three names under 'horse' placed in AB6,AC6,AD6,which in my example attached would be AB6-Garnet,AC6-Jo Anconi,AD6-Blossom.

If it is in the top two then wish for the cells to remain blank.
Sheet enclosed with sample and result.

[JLGWhiz]

Please Login or Register  to view this content.

[gilnic]

Hello JLGWhiz,
Sorry for late reply didn't think anyone had responded.Thank you for your solution.

[JLGWhiz]

Hello JLGWhiz,
Sorry for late reply didn't think anyone had responded.Thank you for your solution.

You're welcome,
regards, JLG