Formula Help - Match multiple cells to create a Win/Loss result

[jkd8594]

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

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Formula Help - Match multiple cells to create a Win/Loss result
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.