Formula Questions

I am not sure if this is possible, but I’m trying to write a IFERROR INDEX MATCH MATCH formula with a consecutive answer. I have some multiple cells with the same Description & I need to match the qty to determine the different cell totals. Attached is the formula with the 1 match which works on 80% of the cells & the 2nd formula is a work in progress

 

=IFERROR(INDEX(Table2[Total Cost],MATCH([@Description],Table2[Description],0)),””)

 

=IFERROR(INDEX(Table2[Total Cost],MATCH([@Description],Table2[Description],0),IF(MATCH(Table2[Qty],Table1[Qty],0)))))

the 2nd formula is not working & not sure if I wrote it correctly

 

By: Christine

Leave a Reply

Your email address will not be published. Required fields are marked *