Can someone please help me with using vlookup to merge two lists based on a
common email address. I want to match email addresses between the two
spreadsheets and bring the data from the second spreadsheet to the matching
record (email address) on the first spreadsheet. I've read all sorts of
online articles and read help, but still can't understand how to get vlookup
to work correctly.

Spreadsheet 1 is a master list with contact information for 400 people
including their email addresses in column R. Spreadsheet 2 is a second list
of 200 names with their email address in column E and the Response in column
F (column 6). I want to exact match records on email address and copy the
Response in column F, spreadsheet 2 to the corresponding email address row in
the new column on spreadsheet 1. The lists have header rows.

I created a new column in Spreadsheet 1.
Then in Row 2 in that new column, I created:
vlookup(R2, (spreadsheet 2 table range to look for matching email address),
(spreadsheet 2 column to grab the Response), False)

* Vlookup is located in cell W2
* R2 in spreadsheet 1 is the cell with the corresponding email address
* spreadsheet 2 column to grab the Response: I tried using 6 for the column
F in spreadsheet two where Response is located. I also tried highlighting
the entire column 6 in spreadsheet 2.
* False for exact match

I can't get vlookup to work properly. I hope that my explanation is clear.
I would greatly appreciate any help.