Need help matching data from one excel sheet with another

[Evilryu]

Newbie! Not sure exactly what Formula I am looking for...

I have two sheets with data

Sheet 1
sheet1.jpg



Sheet 2
sheet2.jpg


I need to match the email address from sheet 2 to the BIB# in sheet 1 so that is shows:

Final Sheet
sheet3.jpg

Your help is deeply appreciated.

[FDibbins]

Hi and welcome to the forum

For future reference, Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)

Having said that, I think you need to use VLOOKUP for this. Put the data from sheet1 onto sheet2, then use vlookup() to find the data on sheet2, based on sheet3

[Sam Capricci]

As Ford told you, a vlookup will accomplish it for you. In the one where you want all start in B2 and use =VLOOKUP(A2,[sheet name]A:B,2,FALSE) then in C2 use the same but with the appropriate sheet name. The sheet name will automatically insert itself if you are in the cell when you write these formulas and click on each sheet.

[Evilryu]

Thanks!!! All clear now!