Show respective IDs

[a_k93]

Hi there,

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

Thanx in advance.
a_k93

[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.

--
Regards,
Tom Ogilvy


"a_k93" wrote:

>
> Hi there,
>
> I am showing a list(dropdown) of Customers in column A. What I am
> looking is, when the user select the customer from the list it should
> display the Code in the beside column (cell) i.e. in column B, but in
> the same row of that the customer is selected. How do I achieve it. My
> all customers are stored in column J and its respective IDs in column
> K.
>
> Thanx in advance.
> a_k93
>
>
> --
> a_k93
> ------------------------------------------------------------------------
> a_k93's Profile: http://www.excelforum.com/member.php...o&userid=32679
> View this thread: http://www.excelforum.com/showthread...hreadid=524855
>
>