Vlookup, finding a second identical value when you have it's row number.

[Eamonn100]

Hi,


I'm using this formula to find some text, =VLOOKUP("Tools",$A1:$B400,1,0). This formula has been simplified for posting.


There are two instances of "Tools".


I've used a formula to find the row number the second value of "Tools" is in. {=SMALL(IF($A1:$A400="Tools",ROW($A1:$A400)),ROW(2:2))}


Is there a way I can find the second instance since I have the row number?


Thanks.

 

[Eamonn100]

It's ok I got this.