Forum Discussion
Table Data
So we plan to use this table to enter the inventory that we have in stock as well as anything we receive. When we enter data into this table, the data need to go into another table based on the c...
You might use the FILTER function, but that won't work in a table, so you'd have to convert the table on the Cage 15 sheet to a range.
Remove all existing formulas and values from B5:G5 down.
Enter the following formula in B5:
=FILTER(InventoryList, InventoryList[Cage '#]=B2, "")
The formula result will spill to 5 columns and as many rows as needed.
