Find first instance of value in a range.

[ECB]

Hello all,

I hope you are well. It's been a while since I was here, and Google has been my friend but I'm really struggling with this one. I clearly can't see the wood for the trees because this seems so simple.

I have a spreadsheet. In Column A I have my marker column 1 to 5000. In columns B to L, I have the names of the players in a football team. So I have 5000 rows of football players in a team, and 12 columns - essentially the columns are the positions of each player - not that relevant to the problem.

What I want to do is put a players name in one cell, and find the first instance of his name in the range, ie, if his name appears firstly in row 5 return the number 5. If it appears in row 4001, then return 4001.

I think index match is the key, but I'm struggling to make it look like anything that might resemble it working.

Any help gratefully received.

 

[farmerscott]

https://www.mrexcel.com/forum/excel...en-match-value-repeating.html?highlight=match

ECB,

I am not an expert in this area, but have a look at the above thread.

cheers.

 

[ECB]

Hi,

Thanks for the reply. I'm struggling to get this to work, I probably just need to spend a bit more time to understand it better.

In the meantime, I've done a dirty fix by running a match on each individual column and then working out the minimum value then running a vlookup based on the minimum value. It does the job but ill work out how to do it properly one day