Auto Populate Cells Dependent on Information in Previous Cell

**senescu** · 07-20-2010, 06:07 PM

Hello,

I do not have much experience with Microsoft Excel so please be very specific with responses. I have Excel 2003.

Question: How do I make a cell auto populate based on the information selected in a previous cell.

Example: Let's say I had 10 players on a soccer team and players names were submitted in column A. Column B had information such as "goals" "assists" "minutes" etc.

I would like Column C to auto populate with the players statistics in Column C based on the name chosen in Column A.

Furthermore I would like to be able to select one, two, or many things in column B to auto populate column C.

Example if "Joe" selected from Column A and if "Goals" selected from column B:

Joe Goals 4

or

Example if "Joe" in Column A and if "Goals" "Assists" and "Minutes" selected in B

Joe Goals 4
Assists 9
Minutes 130

Any information is greatly appreciated!

**Shane O** · 07-21-2010, 08:34 AM

Hi Senescu,

So, in column B you have all the info together? Assists goals and time?

I suggest separating this data by column..

ex:Column A = Name; Columb B = Goals, Column C = Assists and Column D = Time

Either way, though, to do exactly what you want (specify which information is displayed), I think VBA is required.

However, there may be a simpler way depending on how your information is organized...

Can you post your worksheet?

**spreadcore** · 07-21-2010, 11:50 AM

Take a look at using VLOOKUP. or INDEX & MATCH
No macros needed.
Here's 3 examples.
One using VLOOKUP you Just enter the name and it shows all the player stats.

the second using INDEX & MATCH, you enter players name and what stat you want from drop down menus.

the third using INDEX & MATCH & INDIRECT and named ranges, you enter players name and what stat you want from drop down menus.