insert text data using function

[Mosaddeq Aziz]

Hi Guys,

I need help on the following matter. Suppose i have two column A and B. Now
when i insert some text in the A1 cell i want the data automatically set up
in the B1 Cell. Fox example if i type Linux in the A1 cell "Open Source"
will be automatically inserted in the B1 cell but if i insert windows "close
source" will be inserted autoamtically. I tried with if function but no
success. How can i achieve that?

Mosaddeq Aziz

 

[KC Rippstein]

You need to set up all of your possible data entry values for column A on
Sheet2. Then in column B on sheet2, put the values you want auto-populated.
So, on sheet2, A1 is "Linux", B1 is "Open Source" (just type the words you
want without quotes)
When you're done making your list, go back to sheet1. In B1, put the
formula =VLOOKUP(A1,Sheet2!A:B,2,0)

 

[Mosaddeq Aziz]

Thanks Rippstein. Working nicely.

Mosaddeq Aziz

 

[Dari]

Hi KC,

I tried this with my target cell that has a drop down menu, but can't get it to work. It that possible? I tried your formula on a new sheet, which was fine, but on my worksheet, I can't get it right.

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[KC Rippstein]

Can you be more specific, please?
The formula I gave will only return an exact match, so you should make sure
that your list entries are precise (no extra spaces at the end or in between
words, things like that).