Excel 2007 : Using an IF statement along with a VLOOKUP

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.

You use VLOOKUP to return from any column where first column is matched.

e.g.

=VLOOKUP(A2,'Sheet 2'!A:B,2,FALSE) returns emails from column B when Column A is matched. Otherwise you get an error...

to remove the error,

In XL2003 and prior, =IF(Isnumber(match(A2,'Sheet 2'!A:A,0)),VLOOKUP(A2,'Sheet 2'!A:B,2,FALSE),"")

in XL2007 and after =IFERROR(VLOOKUP(A2,'Sheet 2'!A:B,2,FALSE),"")