Choose and option and information pulls up

I hope I am describing this right. I am trying to create a spreadsheet for all the different Myers Briggs personality types. I want to pull down on a menu say ISFJ and in the next column will produce how to communicate to a person who has an ISFJ personality. Can anyone help with this?

You can have a workbook with two sheets. On one sheet, you can list personality types, and how to treat them. On the next sheet, you can have a validation setup to choose from the personality types, and it will use a vlookup to show the information.

Let me know if this helps:

That is exactly what I need, can you tell me how to do it?

Sure:

On your lists page, you enter the personality types (I don't know them, so I used letter combos). Once you have enterred all of them, you can define that range. To do that, highlight all of the personalities (in my case, A2:A6). Once highlighted, press CTRL+F3. A define name menu will pop up. Name that range "Personality". Next, in column B, you can enter the treatments.

Now go to your main entry page. Highlight the column in which you would like to select the personality (do not include the label). Click on Data>validations> in the allows dropdown, choose list, and enter the name of your range =Personality. This will create a drop down, and you can only select personalities from the list page. In column B, use the formula I provided to do a lookup.

Hope this helps. Let me know if you need anything else.

Everything works great for column A, but how do I get column B to automatically pull up with the choice? right now it will only come up as a drop down box.

In column B, just use the formula that I attached in the first example. You do not have to create a validation for column B.

If you can, please post a zipped sample of your spreasheet so I can give help you a bit more.

I'm attaching it

What formula do I need to use for column B?

See attachment:

I am so sorry, I feel like I am making this so much more difficult than it is, but if I save the folder as a difrent name and then try to reopen it comes up with the attached message. How do I keep this from happening when I send this spreadsheet to other people in the company?