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!!

Posted by Aladin Akyurek on July 06, 2001 1:52 PM

Maybe:

=INDIRECT("Sheet4!"&ADDRESS(the-cell-ref-which-shows-row-number,2))

Aladin

Posted by Mark Farr on July 06, 2001 2:37 PM

Awesome!! Thanks so much for the Aladin!