I'm kind of new to this excel-thing, and i'm sorry if my questions seem
childish and terribly annoying.

Anyway I have two list one called names, and one calle
telephonenumbers. These are placed in sheet 2. In sheet 1 i've create
a drop-down list with the data-validation-list etc and I've told th
list to drop-down is NAMES. Based on the names that appear i want th
telephone-nr that "belongs" to that name to show up to the right of th
name in the adjoining cell (these numbers are written i
TELEPHONENUMBERS). Could someone please help me with this problem??

Regard

--
Message posted from http://www.ExcelForum.com