Populating a Data Validation List based on...

Basically, I want to populate a Data Validation based on values in another cell on another worksheet--but, I want to populate it with the values stored in the cell right next to the cell.


http://i32.photobucket.com/albums/d3...n/untitled.jpg

would be an example.


What I want my Data Validation List to do is to look at column B and wherever it sees a certain color--for example, red, I want it to put the corresponding value in column A in the list.

Any ideas? I'm fairly new to excel, but not that new. I was thinking of using a VLOOKUP function but had no idea how to go about it in a list.