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 :).