I would like to have a cell that can be autopopulated based on the content of
a different cell but also have a drop down menu that can effect the 2nd cell.

For example.
Cell #1 is a part number that if known can be entered in and autopopulate
cell #2
Cell #2 is a description of the part number, if you don't know the part
number you can use the drop down list to search and have Cell #1 autopopulate
with the info from Cell #2.

Is this possible?