IF formula with multiple variables

[agu666]

Hello,

I'm relatively new with Excel so I'm having problems with IF formula.

I created two drop-down menus. One with 5 values and the other with 3 values. So there's 15 variations all together. For every variation there's a certain value and I need to show it in one cell.
In very simple words it would look like: If C1=dog and C2=cat, then D1=dogcat. If C1=mouse and C2=cat, then D1=mousecat and so on.
How can I accomplish this? I guess I need one big function? Wouldn't here be too many IF's ?

Thanks in advance

[ConneXionLost]

Hi,

Welcome to the forum!

Try this in cell D1:

=CONCATENATE(C1,C2)

Cheers,

[tony h]

Hi,
as ConneXionLost said you can use concatenate if you are just jining the values together. My guess from your post is that you have something more complicated.

On the attached sheet I have given two possible solutions:
1. A long if statement but this will get unwieldy
2. An illustration of using a table to lookup the answer

Regards and welcome.

[teylyn]

Tony, the OP might be more comfortable with an .xls file

[agu666]

Thank you so much Tony h. That table version really is what I needed. Big thanks again!