Q:

Excel formula to find the second match

I need a formula that finds the second match in a column:  
A   B  
1   Thiago  
2   Joao  
3   Maria  
4   Andre  
5   Thiago  
6   Jose  

Now I have:  
VLOOKUP("Thiago", A:B, 1, 0)

It returns '1'. But it need the second match, row '5'.
Is there a way to do that?

A:

Use: 
=SMALL(IF(A1:A6="Thiago",ROW(A1:A6),""),2)
This is an array formula, so you need to press CTRL+SHIFT+ENTER after inserting it in a cell.

