If(vlookup statement
 

If you are looking for the value in the 4th column that matches one of the
values of the first 3 columns this should work.
Your table is in A1:D20
The value you are looking vor is in F6, the formulas are in F7:F9
Of course you can merge them in a single formula, replacing F7 in the last
formula with VLOOKUP(F6,A1:D20,4,), etc.

Value you are looking for
=VLOOKUP(F6,A1:D20,4,)
=VLOOKUP(F6,B1:D20,3,)
=VLOOKUP(F6,C1:D20,2,)
=IFERROR(F7,IFERROR(F8,IFERROR(F9,"Part 1 - Other")))


"Nikki" wrote:

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