Vlookups with multiple values for same ID

Originally Posted by Haseeb A

Try this in G2 with CTRL+SHIFT+ENTER, rather than just ENTER

=IFERROR(SMALL(IF($A$3:$A$121=$F2,IF(ISNA(MATCH($B$3:$B$121,$F2:F2,0)),$B$3:$B$121)),1),"")

Then copy G2, then paste across & down.

Thanks for the effort man I appreciate it!

I tried this but I got 0! :-s

I changed it to include a larger table array, but still 0.

Anyway, I now understand how I should have phrased my question: "Can we use VLookups with non-unique identifiers".