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!
Bookmarks