Hey all. Wondering if someone can help me. I was googling IF and THEN tutorials but couldn't really find one that would help with what I'm specifically trying to do.


Trying to have a formula that would do this:

IF CELL A1 = A, B, C, D, E... then X
IF CELL A1 = F, G, H, I, J (etc)... then Y

These are not numeric values, they are words...

For example

IF CELL A1 = CAT, DOG, BIRD... then PET
IF CELL A1 = CAR, TRUCK, TIRE... then AUTO

I've got about 20 items to put in the "IF" part, and about 10 different "THEN" results... is this possible to have that many?

Thanks in advance!