Show respective IDs

[a_k93]

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

 

[Tom Ogilvy]

In column B, for example, B1

=if(A1="","",vlookup(A1,J:K,2,False))

drag fill down if you will have dropdowns in multiple rows.