Index and matching 2 different spreadsheets

Hello,

i am trying to index and match two diffrent excel spreadsheets. one has the same info on it as the other except for one column. i'm trying to add that data over on the other spreadhseet becaue not all the names are on the spreadsheet i'm trying to get a result on. please help. example: i'm trying to place the job location to the blank column using index and match, because not all names are on the first sheet.

first spreadsheet:
name address job title age location
john doe - 555 w sample rd - hr rep 35 blank
sally mae - 101 3rd st - assistance 25 blank


second spreadsheet
name address job title age job location
john doe - 555 w sample rd - hr rep 35 georgia
sally mae 101 3rd st assistance 25 florida