Priority Based Lookup

Hi,

Just wondering if someone can help me with the attached file.

What i have on the sheet are 3 removal dates with 3 removal reasons. I need to bring across the date and reason based on the priority table on my right of the sheet.

for example the first row has a 1st removal reason of Blue drive, second removal reason of purple drive and third removal reason of orange drive. Based on the priority table i need the first reason to have a priority of "1" to show itself in the highlighted row along with the date.

Hope this makes sense.

Thank you

Viren