match 2 sheets of data

  • Thread starter Thread starter matt
  • Start date Start date
M

matt

I have 2 sheets of data: first sheet is al companies name and customer#. Second Sheet is Customers addresses who have purchased within the last year.

I want to have sheet 3 have customer# / company / address (of validated customers)

any ideas?
 
-----Original Message-----
I have 2 sheets of data: first sheet is al companies name
Click to expand...
and customer#. Second Sheet is Customers addresses who
have purchased within the last year.
I want to have sheet 3 have customer# / company / address (of validated customers)

any ideas?
Click to expand...

Why dont you take the name and address and give them a
number and connect them with a lookup function.
 
Hi Matt
do both sheets have a common identifier (that is customer# oder a
unique name)?. If yes take a look at the VLOOKUP function

--
Regards
Frank Kabel
Frankfurt, Germany

I have 2 sheets of data: first sheet is al companies name and
customer#. Second Sheet is Customers addresses who have purchased
within the last year.

I want to have sheet 3 have customer# / company / address (of validated
customers)

any ideas?
 
Back
Top