Excel 2007 : Using an IF statement along with a VLOOKUP

[derek7467]

Greetings everyone!

I have an excel file with 2 spreadsheets in it that house my data:

Tab 1: Raw Data, along with a separate Column for my VLOOKUP
Tab 2: Data, Tab 1 pulls from for the vlookup.

What i would like to do is the following: (Use the IF statement)

I would like another column B on tab 1 to return data from tab 2, but only on the results from the vlookup Column A.

Tab 2 is a sheet of usernames and email addresses in 2 separate columns
Tab 1 is a raw data sheet with a bunch of info on it. my vlookup on tab 1 column A only returns results on matched usernames from tab 2.
I would like to have tab 1 display the email address from tab 2 if the username is matched in my vlookup.