Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pulling information from one worksheet into another
In excel sheet #1 I have data with different counties in the US tied to a
zipcode. In excel sheet #2 I have data with zipcodes tied to particular sales reps names. What function do I use when I basically want to search the second worksheet by zipcode, pull the sales reps name and insert it into my #1 worksheet next to the same zipcode (which now will allow me to see the zip code, sales reps name and the county name). It seemed so easy to do, but it's not.... Please help anyone, Monika |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pulling information from one worksheet into another
Take a look VLOOKUP function in Help menu
"Monika" wrote: In excel sheet #1 I have data with different counties in the US tied to a zipcode. In excel sheet #2 I have data with zipcodes tied to particular sales reps names. What function do I use when I basically want to search the second worksheet by zipcode, pull the sales reps name and insert it into my #1 worksheet next to the same zipcode (which now will allow me to see the zip code, sales reps name and the county name). It seemed so easy to do, but it's not.... Please help anyone, Monika |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
Using information from one worksheet, to rename inserted worksheet | Excel Worksheet Functions | |||
Pulling in Information from a worksheet | Excel Worksheet Functions | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
Pulling parts of information from one cell and putting in another | Excel Discussion (Misc queries) |