Hi there,

I am showing a list(dropdown) of Customers in column A. What I a
looking is, when the user select the customer from the list it shoul
display the Code in the beside column (cell) i.e. in column B, but i
the same row of that the customer is selected. How do I achieve it. M
all customers are stored in column J and its respective IDs in colum
K.

Thanx in advance.
a_k9

--
a_k9
-----------------------------------------------------------------------
a_k93's Profile: http://www.excelforum.com/member.php...fo&userid=3267
View this thread: http://www.excelforum.com/showthread.php?threadid=52485