Find Second Occurence of Text...

[eblake]

I know i've seen this here before but after searching for a bit i've been unable to find it.

I need to find out what column some text is in, but I need the second occurence of the text, I've been playing with index/match/vlookup but can't seem to get what I need.

The text is in Row 2 and i need the second occerence of "Cust/LFO"

Any help would be greatly appreciated.

 

[debooo]

=ADDRESS(2,MATCH("Cust/LFO",INDIRECT(ADDRESS(2,MATCH("Cust/LFO",2:2,0)+1)&":XY2"),0)+MATCH("Cust/LFO",2:2,0))


This should work, it will give you the cell reference of the 2nd apperance of "Cust/LFO".

I did not know how long the data in row 2 goes on so I chose XY2 as where it stops looking, possibly you will want to change that.


hope this helps

 

[eblake]

Works perfectly. Thank you debooo