Using multiple criteria with a wildcard to return multiple values

**chrisou** · 11-06-2021, 03:08 PM

Hi Everyone

I am trying to use mulitple criteria including a wildcard to return all values which satisify the 3 criteria in the attached spreadsheet.

The formula in the spreadsheet is using INDEX, SMALL and COUNTIF and works provided that I enter in G4 the full text to be searched as a criteria. However, if I wish to enter a text string using a wildcard as in H4 the formula does not work..! I have text in column C which will not always be a full match but needs to be taken into account if a partial match.

I would really appreciate you help on this problem to return ALL time values in column B which satisfy the 3 criteria

Many thanks

Chris

**Bo_Ry** · 11-06-2021, 03:33 PM

Please try

=AGGREGATE(15,6,$B$2:$B$17/ISNUMBER(SEARCH($H$4,$C$2:$C$17))/($A$2:$A$17=$G$3)/($D$2:$D$17=$G$5),COLUMNS($G9:G9))

**chrisou** · 11-07-2021, 04:08 AM

Hi Bo_Ry
Your proposal works perfectly. Thanks / Merci beaucoup!

**AliGW** · 11-07-2021, 04:16 AM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

Using multiple criteria with a wildcard to return multiple values

LinkBack

Thread Tools

Rate This Thread

Display

Using multiple criteria with a wildcard to return multiple values

Re: Using multiple criteria with a wildcard to return multiple values

Re: Using multiple criteria with a wildcard to return multiple values

Re: Using multiple criteria with a wildcard to return multiple values

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Vlookup multiple criteria and return multiple corresponding values in a single cell.

[SOLVED] Count Unique Text Values Based on Multiple Criteria in Different Columns (inc. wildcard)

[SOLVED] Wildcard vlookup return multiple values

[SOLVED] Return multiple values (matrice) by selection of multiple criteria.

Find text (multiple criteria) in multiple cells, return multiple values if true/false

[SOLVED] How to return multiple values to a single cell based on multiple criteria

Return multiple values based on multiple criteria matches

Bookmarks

Bookmarks

Posting Permissions