I have an INDEX/MATCH formula that looks for an inventory volume and returns the part number associated with it. It's rare, but sometimes, I have the same volume for two or more parts. The formula, however, returns the first part number it sees for every instance of that volume, resulting in duplication and omitting the other part number(s). Is there a way to modify the formula so that it ignores what it has already returned and looks for the next instance of that number?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Solving INDEX/MATCH duplicate returns
- Thread starter kualjo
- Start date
Similar threads
- Question
