Forum Discussion
Help with formula
Hi there, I made a basic stock inventory spreadsheet for the family granite business, but my dad is wanting a column in it to show the value of the offcuts left from jobs. Here is a picture off t...
Hi Adrian,
Better to use Excel tables, for your ranges that could be like (for cell I2)
=IFERROR(INDEX(Cost!$D$1:$D$500,MATCH(C2,Cost!$A$1:$A$500,0))*G2,0)
MATCH finds the row number in Cost sheets for matched colour and INDEX returns the cost from that row.