combo box link field lookup
Posted by Mark Farr on July 06, 2001 1:00 PM
I am using a combo box on a form to choose values from a list on another sheet. I need to place a text value from column b of the lookup sheet back in the main sheet. The combo box give me the ability to link to a cell but all the cell shows is the row number of the selected item. I need to take that row number and go to sheet4 and look up the text in column b on that row.
Wow hope that makes sense!!