Vlookup multiple identical values

Hi All,

Many thanks for any help in advance.

This is my first post, I hope I don't come across as too much of a novice..

Is it possible to Vlookup multiple identical values? or should I be using another function?

i.e. If I want to return the value in column 5 where ever ABC123 appears in the lookup table?

Many thanks again..

Thanks for your help, I will have a read through..