matching and pasting data between worksheets

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup with Multiple Columns to Match 2
Merging/Combining workbook data 5
Merging Data Into Spreadsheet 2
matching data on worksheet 1
Match worksheet 2
Lookup/match value in a different worksheet, and just return a yes 4
Matching records based on a common field 1
Pasting to calculated address 1

Top