Last seen: Jun 7, 2026
Perfect, thank you!
We need help with an XLOOKUP formula that's not working. Trying to have a column in the BOM gather the inventory quantity from the Inventory sheet whe...
@riny Thank you, thank you!
@riny Thank you, that will work. Can you tell us how to "see" the power query used so we can duplicate the action? Also, we were hoping to enter one '...
Hi, we have created sample files. One is the 'Inventory Sample' which has been partly filled in (Inventory, Transactions and Products sheets) using th...
@riny Yes, we have all that in an excel spreadsheet that has worked relatively OK with references back and forth between sheets. The relatively simple...
Here's the same file with assemblies and resulting inventory.
@riny Thanks for replying! We're using Excel for Mac, Version 16.103.2. Here's another example BOM.