Formula lookup separate sheet to get more info after a SUMIF


I have a sumif formula that is working nicely to return the value of a payment that I am getting ZAPIER to add a row to a separate sheet that has all the payments.


=SUMIFS({Square Payments Range 2}, {Square Payments Range 1}, [Participant ID]442, {BIP Online Payments Range 1}, <=[Group Date]442, {BIP Online Payments Range 1}, >([Group Date]442 - 7))

Now I would like to retrieve the Number and transaction type from the same sheet that has the payments. So essentially same criteria that returns the first value that matches (which will be the only value).

I cant get vlookup, match, index to work with the multiple criterias - ID and Date Range. This seems like an easy thing to figure out.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!