Alternative for nested IF with OR

[chaiyya345]

Hi All,

is there any other alternative for this matter, (sample attached). more names, group to be added & what im doing is just nested IF with OR

Please Login or Register  to view this content.

IFS would be great solution but unfortunately, my office is Excel 2016.

Thank-You very much

[FDibbins]

Your sample is fairly cryptic. If thats all you are doing, I see nothing wrong with that.

If you will be having a LOT more options, perhaps a small lookup table, then use vlookup()?

	E	F
4	a	ab
5	b	ab
6	c	cd
7	d	cd

for the extract...
=IFERROR(VLOOKUP(C4,$E$4:$F$7,2,0),"EE")
copied down

[AliGW]

If it ain't broke ...

There isn't going to be anything shorter for the scenario you have given.

[chaiyya345]

Hi, FDibbins, AliGW,

I am thanking you both for the input. I guess, i will just go ahead use this function.
will mark this thread to Solved

Thank-You very much.