vlookup or index-match for multiple columns

I'm attempting to search for the first names in a table and turn up the result of the last column . Unfortunately, my formulas are not pulling up any results. In other words, I'd like to search for column 1 of RESULTS in the REFERENCE TABLE, and have the value of column 4 of REFERENCE TABLE turn up in column 3 of RESULTS.

I've attempted to do this with both vlookup and index-match, but keep returning #N/A values. I've attached the file also if you'd like to see what I've done.

Thanks!


RESULTS
1 2 3
Mike Johnson "Formula"
Beth Smith "Formula"
Bob Heinz "Formula"


REFERENCE TABLE
1 2 3 4
Michael Mike 0 1
Robert Rob Bob 2
Elizabeth Elisabeth Beth 3

The names in column A of the sheets are not the same: Mike is Not Michael, etc.