Issue
When there are multiple results for a look up input, they all show up in the same cell and it can be tricky to determine which information matches across the columns.
Environment
Look Up Table
Cause
Look up results are pulled into the same cell with different sorting rules per column (alphabetical / numerical), making subsequent look up columns difficult to use.
Resolution steps
Workaround:
1. Add a look up table with ONE look up column of its inventory.
2. Add another "Look Up Inventory" table.
3. Type out each inventory result from the first table per row or use the + button to add from structured table (eliminates the need to copy and paste the inventory names).
4. Set up your second look up table as desired.