Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding specific data and changing cells next to the data
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding specific data and changing cells next to the data
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 "fozzetti" wrote: 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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding specific text in one cell and returning data from another | Excel Worksheet Functions | |||
Finding specific data and moving it to a new sheet | Excel Programming | |||
finding blank cell and moving specific data into it | Excel Worksheet Functions | |||
Copying autofiltered data to a specific (changing) row using a macro | Excel Programming | |||
Finding Specific Data and modifying it | Excel Programming |