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
Last edited by agu666; 03-12-2010 at 08:33 PM.
Hi,
Welcome to the forum!
Try this in cell D1:
Cheers,Code:=CONCATENATE(C1,C2)
Docendo discimus.
Please consider:
- Thanking those who helped you. Click the reputation icon
in the contributor's post and add Reputation.
- Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
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.
Hope this was useful or entertaining.
Tony, the OP might be more comfortable with an .xls file
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
Thank you so much Tony h. That table version really is what I needed. Big thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks