To find a way around getting duplicates when running an IndexMatch formula. For example, it looks at column O (O10, for example and then searches through range D2:D115 to return whatever is in the adjacent column A once it finds it.
At the moment, there are some duplicate numbers in column O and so it's always returning the same result. Is there a way of having an extra bit in there somewhere to say "I've already found , so ignore that and find the next result"?
Use this Array* formula:
Obtained from the OzGrid Help Forum.
Solution provided by NBVC.
|How to index across multiple tabs|
|How to obtain validation list values from 3 columns based on INDEXMATCH of value offset from cell|
|How to use Index/Countif based on multiple factors including range|
|How to use SUMPRODUCT with INDEX MATCH multiple criteria|
|How to create VBA for index and match based on sheet criteria|