I have three columns that I need to return a vlookup value.

A B C
8 2 PSS

I want to lookup column A in my table to return the name, if not then lookup
B and return the name, if not then lookup C, otherwise give me "Part 1 -
Other". In this case none of A, B, or C is found so my result should be "Part
1 - Other". My lookup table is below:

CLASSIFIERID GENERICATTRIBUTE1 GENERICATTRIBUTE2
ANH Part_4 Athena Part_4 Athena
21 Part_4 Specialty Part_4 Specialty
24 Part_4 Specialty Part_4 Specialty
CR Part_4 Specialty Part_4 Specialty
EVN Part_4 Specialty Part_4 Specialty
PMY Part_4 Specialty Part_4 Specialty
19 Part_4 Specialty Part_4 Specialty
GMT Part_4 Specialty Part_4 Specialty
11 Part_1 Select Part_1 Select
3 Part_3 Equip Part_3 Equip
PS Part_1 Select Part_1 Select
9 Part_1 BLD Part_1 BLD
MAL Part_1 PSP Part_1 PSP
MMM Part_1 PSP Part_1 PSP
WA Part_1 PSP Part_1 PSP
BMI Part_1 PSP Part_1 PSP
DJO Part_1 PSP Part_1 PSP
KEN Part_1 PSP Part_1 PSP
AEP Part_1 PSP Part_1 PSP