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.
name address job title age location
john doe - 555 w sample rd - hr rep 35 blank
sally mae - 101 3rd st - assistance 25 blank
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
Now write below formula in Sheet1 column location which suppose in A2
You are writing this formula in blank cell of sheet1
Sheet2!D = This is the column of location in sheet2
Match(A2 This is the Name which you are searching for from Sheet1 to Sheet2
Sheet1!C:C This is the column "Name" in Sheet1
Just try above formula and do let me know ...........