Index and matching 2 different spreadsheets [Closed]

 valid numbers -

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

1 reply

Registration date
Sunday April 12, 2009
Last seen
February 16, 2010
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 ...........

Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

hi, I tried but the formula can't seem to work
example s/s 1 have column a-d which is similar to s/s 2, and i'm trying to index column e in s/s 1 over to s/s 2.
how do I do that?
> fee
I am trying to bring back a value in column "B" after performing a vlookup function to determine that (sheet!absolute range does have a match with column AX2:AX4000 - for example)

So I think we are trying to do the same thing - Will an if then work and can someone provide an example? Thank you.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!