Index Match, search 1 criteria across multiple columns

**FlameRetired** · 10-21-2016, 01:39 AM

Thank you izk630 for the upload.

None of the examples you provided until now had concatenated strings containing the lookup values.

This is a different problem. There is evidence of multiple matches. I am not surprised my formula did not work.

**izk630** · 10-21-2016, 02:32 AM

any ideas how to solve this? index match or vlookups work fine with repeated values, it just returns the first found or max/min if specified.

Index Match, search 1 criteria across multiple columns

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Index Match, search 1 criteria across multiple columns

Re: Index Match, search 1 criteria across multiple columns

Thread Information

Users Browsing this Thread

Similar Threads

Index Match with multiple criteria (two lookup columns)

Index Match with Multiple criteria in rows and columns

Ignore Blanks for INDEX/MATCH with multiple criteria search

[SOLVED] Return Multiple values from a column with index and match, and search criteria

Index/Match to search multiple columns

[SOLVED] INDEX+MATCH with multiple criteria across both rows and columns

Using Index Match to search multiple columns

Bookmarks

Bookmarks

Posting Permissions