copy address information from one sheet to another if customer name matches vendor name

S

Scott Streit

I am preparing my customer and vendor list to be imported into a new
database application.

I have a workbook with page 1 containint my vendors and page 2
containing my customers.

I want to automatically pull the address infromation from the vendor
sheet to the customer sheet is the names are an exact match.

Can anyone shed some light on this for me?
 
P

prabhuraaman

You can use the VLOOKUP function

Let's assume
SHEET1 contains the name of vendors
SHEET2 contains the name of customers

Then your formula in the cell B1 of SHEET2 would be(where the name of
the customer is cell A1)
=VLOOKUP(A1,Sheet1!A1:B3,2,FALSE)

For more information,see Microsoft help.
 

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

How do I move entire row from one excel sheet to another 3
If Name is checked on Sheet 1, mark appropriate column in Sheet 2?? 2
Copy Data From Varying Lines to One Sheet 1
Search for rows in one sheet and copy into another sheet based on customer id 1
Look up and match Vendor name in one cell of worksheet from list ofmultiple Vendor names in column o 2
gather information from another sheet with one related value 4
Excel Help to copy information from one row at a time to another sheet 1
Sumproduct function allow a lookup for one Date to check if it fallsin Date Range in other table 9

Top