Merge Two Sheets Based on Matching Value

[matthewcb]

I have two sheets with a Unique ID that I'd like to match and generate a third sheet. The third sheet would consist of First Name, Last Name, ID number where the phone numbers match from between sheets.

Sheet 1: A = Fname, B = Lname, C = Phone
Sheet 2: A = message, B = Phone

I'd like to make a Sheet 3: A = Fname, B= Lname, C = Phone, D = Message

Is my only option to try and get on a PC and use MS Access? Never had to do this in Excel before.

[Kaper]

As I understand, phone number is your unique identifier
then take A = Fname, B= Lname, C = Phone in sheet 3 directly from sheet1
Either by simple copy, or with formula

Please Login or Register  to view this content.

and
then in D1 use nested INDEX and MATCH functions. Should read something like:

Please Login or Register  to view this content.

match function will find position of your C1 (phone number) in column B in sheet2.
and item from column A in sheet2 (a message) located on the same position (= the same row ) will be returned.

If you expect that some people could nave no matching messages - you can use additional function: IFERROR