How do I write an VLookup in a one to many relationships.

I have 2 worksheets, my source has a unique value and I want to bring in >1 values in my vlookup.

If that isn't possible, is there another solution?

Thanks for your time.  :)