Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pulling Data from a different worksheet (Need Help)
I have a work book, lets call it "Addresses", in this work book I have two
worksheets lets name them "A" & "B". In worksheet "B" I have a listing of employee names and addresses, example: A1 A2 A3 A4 A5 A6 A7 Location code / employee name / address 1 / address 2/ city / state / zip each of the above is in a seperate cell in worksheet "B". I want to be able to enter the location code in one cell, (say A2) of worksheet "A" and then have the corresponding employee name, address, etc. pull over from worksheet "B". I know I can use a VLOOKUP, to do this but the problem i run into is when there are multiple employees for the same location code. I need all the employees to somehow pull over, the vlookup will only give me the first one listed. Can anyone out there help me with this problem?? I could really use some help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pulling Data from a different worksheet (Need Help)
"jeo1" wrote: I have a work book, lets call it "Addresses", in this work book I have two worksheets lets name them "A" & "B". In worksheet "B" I have a listing of employee names and addresses, example: A1 A2 A3 A4 A5 A6 A7 Location code / employee name / address 1 / address 2/ city / state / zip each of the above is in a seperate cell in worksheet "B". I want to be able to enter the location code in one cell, (say A2) of worksheet "A" and then have the corresponding employee name, address, etc. pull over from worksheet "B". I know I can use a VLOOKUP, to do this but the problem i run into is when there are multiple employees for the same location code. I need all the employees to somehow pull over, the vlookup will only give me the first one listed. Can anyone out there help me with this problem?? I could really use some help. Never mind this question, I was able to figure out the solution on my own. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling data into today's worksheet from yesterday's worksheet | Excel Discussion (Misc queries) | |||
Pulling data through to another worksheet | New Users to Excel | |||
Pulling data from one worksheet to another | Excel Worksheet Functions | |||
Pulling Data from Another Worksheet | Excel Discussion (Misc queries) | |||
Pulling data from different worksheet | Excel Programming |