nth occurrence of string in multi-column range

i got a table of gamescores from multiple (card)games between some players like this:

A	B	C	D	E
Game 1
name:	An	Bert	Carol	Daniel
score:	10	5	20	30
...other gamedata:	...	...	...	...
...other game data:	...	...	...	...
Game 2
names:	Eric	An	Bert	Carol
score:	5	10	10	30
... other gamedata	...	...	...	...
...other gamedata:	...	...	...	...
Game 3
names:	Carol	Fritz	Eric	An
score:	5	10	10	30
... other gamedata	...	...	...	...
...other gamedata:	...	...	...	...

I need a function that is able to return the index (a function for columnnumber and one for rownumber) of the n'th occurrence of a player name, say "Bert".
notice that the name "Bert" can appear in different columns, but only once in a row. the nth occurrence is to be counted from top to bottom, across the 4 columns.
for example the 2nth occurrence of "Bert" is in D8, so i need the function(s) to return 4 (column) and 8 (row), given the inputs "Bert"and 2

I hope my question is clear. a solution without the use of VBA's or Macro's would be ideal, since i have no experience with those (i am reading up on them)

thx for any help on the subject

Post in the VBA sub, expect a VBA solution. If you want to use a function, look into VLOOKUP and/or INDEX and MATCH.

Anyway, here's the VBA. Change Namer and nth to whatever you want, or you could set them equal to an input cell on your spreadsheet if you don't want to change them in the code.

Please Login or Register  to view this content.