I believe I need a formula in the report cost column(G2) when matching suffix(B2) and code(F2), then from the table, inputs the data in the intersecting row and column.
I have cut the files down from the very big originals for ease.
I believe I need a formula in the report cost column(G2) when matching suffix(B2) and code(F2), then from the table, inputs the data in the intersecting row and column.
I have cut the files down from the very big originals for ease.
Try this,
=INDEX([Table.xls]Costs!$C$3:$U$32,MATCH(F2,[Table.xls]Costs!$B$3:$B$32,0),MATCH(B2,[Table.xls]Costs!$C$2:$U$2,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks