| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
matching and pasting data between worksheets
I have a list of customer numbers on one worksheet. On a second worksheet, I
have some of these customer numbers and a shipping address. I would like to use a function that will find a match between the two columns of customer numbers and, when found, paste the corresponding shipping address which exists as 4 columns in one single row per customer. I am a novice and can't seem to get a handle on the MATCH or VLOOKUP functions so please be very explicit. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
matching and pasting data between worksheets
You may want to start by reading Debra Dalgleish's notes on =vlookup():
http://www.contextures.com/xlFunctions02.html TyCGibbs wrote: I have a list of customer numbers on one worksheet. On a second worksheet, I have some of these customer numbers and a shipping address. I would like to use a function that will find a match between the two columns of customer numbers and, when found, paste the corresponding shipping address which exists as 4 columns in one single row per customer. I am a novice and can't seem to get a handle on the MATCH or VLOOKUP functions so please be very explicit. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MATCHING AND PASTING DATA | Excel Discussion (Misc queries) | |||
| How do I compare data in two worksheets to find matching cells? | Excel Discussion (Misc queries) | |||
| matching data to merge two worksheets | Excel Discussion (Misc queries) | |||
| Matching/merging data from two worksheets | Excel Worksheet Functions | |||
| Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
Linear Mode
