With all due respect to the Moderator I think there is a bit more in it than what is explained in the fiveminuteslessons link.
If I understand it correctly, OP wants to use a normal VLOOKUP-formula if there is no duplicates for a given number in column A and another formula if there is duplicates.
If you can accept helper cells as shown in column F, I think you can use the array formula in column G.
I have not done any serious testing, so come back if you get problems.
|