List box option

[Mikew]

Hi
If I have a list box ( using data-validation )in cell A1
sheet 1 with clients names
and in sheet 2 I have the client names in A1-A20 and the
data Phone # in B1-B20,is their some way I can transfer
the correct phone # to cell B1 in sheet 1 depending on
the client selected from the list box

 

[Bob Phillips]

Hi Mike,

In B1, add this formula

=INDEX(Sheet2!B1:B20,MATCH(A1,Sheet2!A1:A20,0), 1)


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Mikew]

Perfect....Thanks