Auto entry based on table

Hi There,

I have a table with three columns, "Color", "Number", "Amount". In another table, I created the same column headers and I want to know if there's a way to have excel auto enter the "Number" and "Amount" fields based on the "Color" that the user selects from a drop down. I already used data validation for the "Color", but I don't know how to go about the auto-entering. Attached is my sample.

I would greatly appreciate it if anyone can help me!

Thanks!