Formula for looking up and copying from another worksheet?
 

In worksheet 1, column B, I have a drop down list to choose from a number of customer numbers listed in worksheet 2. When the customer number is chosen from the dropdown list, I want the address info from from worksheet 2 columns C,D,E, F,G to be copied to the worksheet 1 columns C,D,E ,F, G. I know it can be done but I can't figure out how. Help?

Formula for looking up and copying from another worksheet?
 

hi,

i guess there are the customers numbers in column B of sheet 2

put the following formula in worksheet 1 range C1

=INDEX(Feuil2!C:C,MATCH($B1,Feuil2!$B:$B,0))

then copy to right

--
isabelle



Le 2012-04-13 13:29, tmorefi a écrit :
In worksheet 1, column B, I have a drop down list to choose from a
number of customer numbers listed in worksheet 2. When the customer
number is chosen from the dropdown list, I want the address info from
from worksheet 2 columns C,D,E, F,G to be copied to the worksheet 1
columns C,D,E ,F, G. I know it can be done but I can't figure out how.
Help?