I’ve been on this issue for a couple of hours, and can’t seem to get my head around it.
I am trying to check for inventory levels for an order by looking up its unique SKU value.
My formula is: thisRow.SKU.FormulaMap(Lookup([Inventory Levels],Sku, CurrentValue))
““thisRow.[VALUE 1 SKU]FormulaMap(Lookup([LOOKUP TABLE],[LOOKUP COL SKU], CurrentValue))””
This works, if the row only has a single SKU, but it does not work if the row has more then 1 SKU values.
I made an example doc, to show the issue here: https://coda.io/d/Inventory-levels_d7tBR_4hmaG
As you can see, the #2 shows the value correctly, but #1 doesn’t show anything. #1 should show each SKU from the other table as well.