P
Pjotr
I have one excel workbook with 2 columns: Manufacturer and Vendor
I have another workbook with partnumbers, quantity etc. etc. I want a column in this 2nd workbook where you can select a Manufacturer from the first workbook, and it should then display the Vendor in the next cell to the right.
The first workbook will be updated by someone else independently. (If they decide to change the Vendor for a certain Manufacturer, it should update this in my 2nd Excel workbook).
I've gone through the help file, but can't get this to work.
Please advise.
I have another workbook with partnumbers, quantity etc. etc. I want a column in this 2nd workbook where you can select a Manufacturer from the first workbook, and it should then display the Vendor in the next cell to the right.
The first workbook will be updated by someone else independently. (If they decide to change the Vendor for a certain Manufacturer, it should update this in my 2nd Excel workbook).
I've gone through the help file, but can't get this to work.
Please advise.