Multiple IF statements shorter way

[nur2544]

Dear all, Here is a five if statement formula need to shorter way . currently I am doing all together but it looks big formula . is there any alternative small formula to solve my issue ?

H2=IF(B2=G2,"cd com","")
H2=IF(C2=G2,"cd def","")
H2=IF(D2=G2,"cd noo","")
H2=IF(E2=G2,"cu ope","")
H2=IF(F2=G2,"cd cdn","")

[Pepe Le Mokko]

What does your " big formula" look like?

[ragulduy]

Maybe:

=IFERROR(INDEX({"cd com","cd def","cd noo"," cu ope"," cd cdn"},MATCH(G2,B2:F2,0)),"")

[Speshul]

Mine came out longer than I thought it would, but it works

Enter this Array Formula using Control + Shift + Enter
=IFERROR(CHOOSE(SUM((G2=B2:F2)*{1,2,3,4,5}),"cd com","cd def","cd noo"," cu ope"," cd cdn"),"")

[nur2544]

Hi Ragulduy & Speshul , both of your formula is working excellent . thanks for your time

[TMS]

As a third option:

=IFERROR(INDEX({"cd com","cd def","cd noo","cu ope","cd cdn"},CHOOSE(G2,B2,C2,D2,E2,F2)),"")

But probably no better than the options you have already.

Regards, TMS

[TMS]

Thanks for the rep.

[Jacc]

Or maybe a HLOOKUP formula?