Finding specific data and changing cells next to the data

[fozzetti]

I have a spreadsheet that is segmented with 1 collumn full of information and
then two collumns next to that information. I'm trying to populate the
collumns next to my information based on what's written in the main
informational column.

For example:

a15: "star trek" I want excel to auto populate b15: "barter" and c15: "9/11"

I will have several different values for the cells in column A, and would
like columns b and c to populate accordingly.

Is this possible. I've tried several different options with find/replace and
macros.

Any help would be much appreciated. thanks...

 

[Squeaky]

How many different entries in "a" will you have and how many different
"answers" will you have in column b and c? Will "star trek" appear many times?

If you create a table in say columns e, f, and g with "star trek" in "e",
"barter" in "f", and "9/11" in "g", Assuming your list starts in A2 you can
place this in cell b2:

"=vlookup(a2,(e$2:g$100),2,false)" without the quotes.

Copy it down the length of your list. Also G100 represents the list 100 rows
down. Change that to your size.
In C2 place:

"=vlookup(a2,(e$2:g$100),3,false)" without the quotes. Copy down

Also, entering in "9/11" will give you a date. You will need to put ' in
front of it

Squeaky