1 Answers
A:
You can combine and calculate summaries based on the looked-up information by first creating a relation between your main data table and the lookup table, then utilizing the 'filter' function in a formula to select relevant data from the lookup table based on the matching value in your main table.
Coda
CodaDisclaimer
Techjockey’s software industry experts offer advice for educational and informational purposes only. A category or product query or issue posted, created, or compiled by Techjockey is not meant to replace your independent judgment.
20,000+ Software Listed
Best
Price Guaranteed
Free Expert
Consultation
2M+
Happy Customers