Autopopulating on other tabs based on values in various columns...

[armofpilot]

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