Hi All
Please see attached my working sheet where the top table is the racing selections made by our team. The bottom table is the racing results that we will input manually to be used as our raw data. The aim is to have the selections made by the individual are defined as a win or loss
Looking at row 6 as an example id like to create a formula in H6 the identifies if race number (C6) matches C26:C29 or C33:C35 then D6 matches D26:D29 or D33:D35 it will label H6 as "Place" or "Loss"
Any help is appreciated
Please see attached my working sheet where the top table is the racing selections made by our team. The bottom table is the racing results that we will input manually to be used as our raw data. The aim is to have the selections made by the individual are defined as a win or loss
Looking at row 6 as an example id like to create a formula in H6 the identifies if race number (C6) matches C26:C29 or C33:C35 then D6 matches D26:D29 or D33:D35 it will label H6 as "Place" or "Loss"
Any help is appreciated