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:
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
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!