I'm creating an input form for my accounts payable person to use for entering vendor invoice information. I want to create a drop down list in a cell that will display 2 columns of information (vendor # and vendor name). When the appropriate vendor name is selected, the corresponding vendor number will populate the cell. What is the best method for doing this? I'm familiar with drop down lists but that only populates the item you select. Thanks
Denny Riffert
Evansville, IN
Bookmarks