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