Formula for looking up and copying from another worksheet?

T

tmorefi

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

isabelle

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 :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and Paste Word 2010 0
lookup two different variables 0
Vlookup? 1
Help with lots of formulas 3
IF Lookup Formula 2
Formula than understands midnight? 26
Nested If statement or lookup? 1
Syncing between source worksheet and dependent worksheets 0

Top