•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Creating Master List from Master BOM
Our take
Creating a Master List from your Master BOM can streamline your data management process, allowing you to focus on meaningful insights. To achieve this, you need a formula that efficiently checks for values within the specified array (E137:L153) and retrieves the corresponding descriptions from the same row. The challenge lies in ensuring the formula skips empty or zero-value cells, seamlessly progressing to the next available entry.
This is a simplified version of what working on. I am trying to create a formula that test if a cell has value (in an array, E137:L153) and returns the related description cell in the same row. So I am trying to make a Master list (below of image) from the information in the Master BOM (top). Specifically I am not sure how to get it to skip rows that have no value (or 0) and move on to the next cell under (If no cells under, then the test moves on to the top row of the next column).
I've used a combination of setting variables and indexing arrays, but I can't figure it out.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience