Finding the first instance in a column and returning value

[ollyhughes1982]

Hi. In my file (link below) and worksheet 'Completed Unique E(V)', is there a way to make it auto-populate column B (and subsequently the other columns), rather than the manually entered entries I have at the moment? I have tried various ifs, matches and vlookups etc. but can't seem to get it to work. I just want it to pick up the first instance (i.e. all those that have 1 in column AO in the ‘All Completed Runs’ worksheet) of each event from column C in the ‘All Completed Runs’ worksheet. So I then have a list of my unique events, as per the manual entries now. I assume I then just offset or something to populate the other cells on each row?

parkrun - My parkrun Record - WORKING.xlsx

Thanks!

 

[Fluff]

As a matter of info, did you try the formula in post#6 & did it work, or did you get a #NAME error?