Hi all,
Need a formula to retrieve the competitors names and it's color from the score sheet.
Names are on cells E11, E27, M11, M27, colors are on cells E10, E26, M10, M26
The formula to retrieve the competitors names should be on L6:L9 matching their scores and color.
The formula to retrieve their colors should be on D6:D9 matching their scores and color
I have attached an example workbook for reference
Thanks in advance for any help
Bookmarks