LinkedIn
Twitter
Greetings all!
Wondering if I can get some guidance please 
Been scratching my head for hours and it feels like I am missing something very elementary!
I am using the following lookup:
lookup([Inventory],โRecordsโ,โInventoryโ,โHome Inventoryโ)
Where [Inventory] contains my products and โHome Inventoryโ gives the inventory count of each product. โRecordsโ is the name of my table that contains the inventory count, and โInventoryโ is the name of the column to lookup in the โRecordsโ table.
The result however (despite the different products contained in [Inventory] and their associated inventory counts, is always just the first answer in the row of
โHome Inventoryโ.
i.e the first product count under โhome inventoryโ is 6, and this answer 6 is repeated for all other products.
As a test, when I swapped out [Inventory], with โxxxโ (where xxx is some product contained in my list, it does give the correct answer. I tried this with several products and the function works. Soโฆwhat am i doing wrong? 
Thanks in advance!
