Vlookup with duplicates

[harrisj_]

I want a vlookup to occur when there is duplicate data in the Lookup value and the table array. Is there a way that the vlookup can present the first match, and then if there is a duplicate it notices, then lookup and present the second one?

Thanks in advance

[alansidman]

This link should give you a UDF that you can download that will do the trick.

http://www.excelfox.com/forum/f12/vl...iple-values-4/

Be sure to scroll through the whole link as there is an update after the first posting.

[harrisj_]

Thanks!
But is there a way it can be shown in a formula rather than vba code? Such as (1,2) at the beginning to present first one first