No way: H/VLOOKUP will always return the 1st occurence.

HTH
--
AP

"shakey1181" a écrit dans le message
de news: ...
When using V or H lookup, is there anyway to get the function to return
the
reference for the second occurence of what it is looking for? So, I am
looking for the number 23, but it appears tiwce on the sheet and it is the
second one I need.

If that makes any sense, thanks in advance