Merging Data Into Spreadsheet

[Icehearted]

Have a question I hope that someone can answer. I have two excel workbooks
each with one sheet. Spreadsheet A contains solely a customer name in Column
L. What I would like to do is import the data from Worksheet B into
worksheet A if there is a match found.

Worksheet B contains customer names, along with address, city, state, zip,
phone, email address, etc, each in their own individual columns. Also its
important that if no match is found that an error pops up.

Is this easy to do or relatively hard?

Appreciate any feedback and happy Friday .

 

[Icehearted]

Hi,

The customer names may or may not be an exact match. Can V-Lookup do an
approximate match or truncated match.

The company name (workbook B) is located in column n.

 

[Icehearted]

Hmmm.. exact match seems like the best solution at this point. I can
manually look up the ones that come back as no match. How would the formula
look?

Worksheet A (this is the sheet in which data needs to be looked up)

Worksheet B (this is the sheet on which the data, if matched) needs to go

The lookup would be done by company name strictly. Worksheet B has only a
company name. I would take that company name and look it up in Worksheet A
returning with it the other columns of information such as street address,
city, state and zip. The company names are "generally" an exact match or
not. For example, ABC Company, not Company ABC.

Hope this makes sense , thank you for all your comment.