Maybe you can use the technique that Chip Pearson shares:
http://cpearson.com/excel/lookups.htm

Look for Arbitrary Lookups

shakey1181 wrote:

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

--

Dave Peterson