Help please - need to get data from 2 sheets combined into 1

Hi All,

Really hoping this is an easy one, but I don't even know where to start.

I have 2 worksheets:

Worksheet 1 has my employee names in Column B. I have information that needs to be filled in in Column L, M, N, P.

In Worksheet 2 I have employee names in Column A. And the information for Column L is in B, M =C, N =D, and P=E.

Worksheet 1: User ID (L) Telephone Number (M) Outside Tel # (N) Cluster (P)
Worksheet 2: User ID (B) Telephone Number (C) Outside Tel # (D) Cluster (E)

The difficulty is that some of the names on worksheet 1 do not exist on worksheet 2 (and vice versa).

So what I need is for The user ID's to be compared and if the same then copy the correct info from worksheet 2 into worksheet 1.

As an added bonus I need to know what names were NOT found from worksheet 2 on Worksheet 1.

Any help is greatly appreciated before I have to manually do 1500 lines.

Thank you!

It seems like an IF/Vlookup string is needed... this may not be exact... but hopefully close enough for you to tailor to your specifications.

Formula:

Please Login or Register  to view this content.

This may just work for you... copy into column Q on Sheet 1 then take the formula and drag down to last cell with data in it. If the response comes back as "OOPS" then the row of information pertaining to that cell is not on Sheet 2... if the data is on BOTH sheets then it should come back as the USER ID
If you need to transport the data from one sheet to another for USER IDs that are on both sheets but not the other info... use a simple VLOOKUP formula to handle it for you.