If cell A = "value A", autofill cell B to "Value B" - help please!

[hollypop]

I need a function in my spreadsheet that would work as such:

if cell A1 = "Order Type A", cell B1 would populate with additional predetermined information

I have no idea what this type of function is called or where to even start when looking! It doesn't appear to be Data Validation, but maybe I'm looking in the wrong spot?
All of the information I will be adding is only text, no numbers.
Any suggestions?
thanks!

[loginjmor]

Hi -

Could you use this formula in cell B1?

=if(a1="Order Type A",predetermined information,"")

[hollypop]

Just tried that and the result is "FALSE"
This may be a little more complicated that how I originally described it.
What I have is a set of conditions that I need filled out, so if a specific order type is requested, the user knows that this information will have to be added as well.
The additional information has formatting and even drop down menus which I would like to keep active if possible.
I've tried just having it in a different worksheet, but I've been asked to consolidate into one and this information shouldn't be noted unless absolutely necessary.

Clear as mud this time?

[loginjmor]

Hi -

Would it be possible for you to upload a sample spreadsheet that we can look at? I think that would help clarify what you are trying to do.

[hollypop]

I think I've got it - my problem seemed to be that I was trying to input all of my data into one area, when it worked better to be able to input it into individual cells. The if forumulas worked, thank you!

[ChemistB]

The additional information has formatting and even drop down menus which I would like to keep active if possible.

This is the tricky part. Functions do not transfer formatting as a rule. If you are looking at transferring formatting and things like dropdown menus, then you are probably looking at a VBA solution.

[hollypop]

I think that may be getting more complicated than is necessary in this situation. I'd love to do it, but it's not necessary. Maybe next time!