Multiple Instances Vlookup/Array?!

[excel_2009]

Hi excel gurus,

I have the following data:
(excluding the format columns, as that is the results i require but my vlookup skills arent aiding me into finding a solution)

The sheet where the vlookup results would come from:

can anyone please help me?!?! i looked online and i stumbled across "array" vlookups but i have never used them before?!

p.s the order of the results doesn't matter

Thank you!

 

[Misca]

You'll find a solution to your problem from this video: http://www.youtube.com/watch?v=132ZdpxBm1U