0

I have a spreadsheet (table1) that looks like

        A      B       C
1      name   group   cost
2     asset1  X        100
3     asset2  X        75
4     asset1  XI       120

I'm trying to use INDEX-MATCH to fill out the cost column in an identical table (table2) in another sheet:

        A      B       C
1      name   group   cost
2     asset1  X
3     asset2  X
4     asset1  XI

In cell C2, I have tried =IF($B2 = 'table1'!$B2, INDEX('table1'!$A$1:$C$4, MATCH($C2, 'table1'!$A$1:$A$4, 0), MATCH('cost', 'table1'!$A$1:$C$1, 0)

But it doesn't seem to differentiate between groups, outputting (after I drag down) asset 1 from group X twice:

        A      B       C
1      name   group   cost
2     asset1  X        100
3     asset2  X        75
4     asset1  XI       100
user4740374
  • 109
  • 4

0 Answers0