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.