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?
not as such but you can use helper column or array formulas to get multiple returns.
here is a simplified version
Last edited by martindwilson; 08-26-2011 at 09:31 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Can you provide an example of these? I have a column to the side that finds the row number of the first return, and I thought I could use that in an IF statement so that a duplicate entry would start looking in the next row. Haven't been able to figure out how to make that work with INDEX/MATCH though.
see post #2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks