Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet formula incorrect after copying to another worksheet | Excel Worksheet Functions | |||
Copying formula into another worksheet | Excel Worksheet Functions | |||
Copying a Formula which contains a link to another worksheet | Excel Discussion (Misc queries) | |||
Copying result of formula into another worksheet??? | Excel Discussion (Misc queries) | |||
Copying RESULTS of a FORMULA to another worksheet | Excel Programming |