Using Excel 2010

I have a spreadsheet that has a table containing a list of tools purchased from several different vendors. I've attached a screenshot:

There is another worksheet in the file where I am tracking the receiving of the different tools. Column C of the other worksheet contains the Vendor Name and Column D will contain the Item Description.



What I'm trying to accomplish is setting up Column D to only display the Item Descriptions of the tools where the Vendor Name in the table (see screenshot) matches the Vendor Name in Column C. In other words, if I enter Allegheny Tool Supply in Column C, I only want to display the Item Description values in Column D for the records where Allegheny Tool Supply is the Vendor Name in the table.

Is this possible? If so, how?

Thanks very much!
Doug

Attached Images

Table Screenshot.JPG (28.7 KB, 19 views)