I have a list of values where some are the same. How can I use vlookup and
have it give me the result instead of coming up with error?

eg:
i want to lookup 4788000 and have give me the results from list 3 ie 21,31
4332000 39 21
4788000 76 45
3990001 65 45
3420001 74 45
4560000 74 40
3192001 87 49
7410001 59 31
5472001 56 32
5700001 69 36
4788000 54 31

Can I also have it lookup as above but give me the result according the
number in column 2? ie give the result 21,31 or 31,21?