I need to lookup values and return unique colors

I want to lookup "First Name" and "Last Name" of Sheet2 in Sheet1 and return only one color which is the lowest among others: red = the lowest, green = the highest, amber = yellow (between red and green). For example, David Guetta has yellow, green and red, and I need a formula or VBA code to return only the lowest (in this case red). Aaron Ramsey has yellow and green, but I need yellow which is lower than green. But "First Name" and "Last Name" must be our criteria to lookup and return corresponding but only the lowest one.