Linked information in drop down boxes

[rogator]

I am trying to set up a log form to use at work. It involves multiple drop down boxes, all of which contain only one subject of information.
The problem I am having is that I would like to select from a drop down list a product name and have the product code and package size automatically placed into cells located elsewhere on the form. Any help would be greatly appreciated.

 

[acw]

Hi

Have a look at the VLOOKUP function. You can use the selection from the drop down list as the key to return the other information.


HTH

Tony