Data validation using conditional parameters in Excel table
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
|