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

=Sheet1!A1

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

=INDEX(Sheet2!A:A,MATCH(C1,Sheet2!B:B,0))

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