armofpilot
New Member
- Joined
- Mar 27, 2014
- Messages
- 8
Is there a relatively simple way to autopopulate a column on a second tab based on the corresponding values in multiple columns on another tab?
I'm using Excel 2010 and Windows 7
Specifically:
Tab One, column B has a bunch of text options chosen from a drop-down, whose options exist in Tab Two, column A. I would like the values from Tab One, Column D to cross-populate to column C on Tab Two, when the corresponding text matches.
Tab One:
Column B Column D
Apple red
Banana yellow
Coconut brown
Tab Two:
Column A Column C
Apple I want this to read red automatically
Coconut I want this to read brown
Banana I want this to read yellow
I anticipate this might not be that simple a fix but if anyone has any ideas.
Thanks,
Allison
I'm using Excel 2010 and Windows 7
Specifically:
Tab One, column B has a bunch of text options chosen from a drop-down, whose options exist in Tab Two, column A. I would like the values from Tab One, Column D to cross-populate to column C on Tab Two, when the corresponding text matches.
Tab One:
Column B Column D
Apple red
Banana yellow
Coconut brown
Tab Two:
Column A Column C
Apple I want this to read red automatically
Coconut I want this to read brown
Banana I want this to read yellow
I anticipate this might not be that simple a fix but if anyone has any ideas.
Thanks,
Allison