I am working on a spreadsheet that has three columns. A(Equipment
Description) C (Part Number) and AA (Price Each)
What I would like to be able to do is to choose either column A as a drop
down or Column C as a drop down (be able to start entering and it jump to the
description) and after I choose an item out of A or C that it would auto
populate the the other colmun that was not choosen along with the price. The
other catch is that I do not want the price list description nor part number
within the same workbook.
Thank you in advance for your assistance.