Help with returning value from two criteria

Ludwig ✭✭
edited 01/03/22 in Formulas and Functions

I want to fill the empty green field by matching the yellow and blue fields.

I've tried Index collect and index match match.

=INDEX(COLLECT({QuantityOverview}, {PPEReceiptOverview Range 1}, Name@row, {PPEReceiptOverview Range 2}, [1 Quantity]1, 1)) returns #INCORRECT ARGUMENT SET



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!