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. |
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 |
All times are GMT +1. The time now is 02:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com