Index and matching 2 different spreadsheets

Closed
cookie - May 4, 2009 at 10:26 AM
 valid numbers - Oct 28, 2009 at 01:14 PM
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
Related:

1 reply

mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
160
May 6, 2009 at 01:02 AM
Now write below formula in Sheet1 column location which suppose in A2

You are writing this formula in blank cell of sheet1
=INDEX(Sheet2!D:D,MATCH(A2,Sheet1!C:C,0))
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 ...........






5
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?
0
valid numbers > fee
Oct 28, 2009 at 01:14 PM
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.
0