Wildcard match, lookup with text and numbers

In Excel I have a list of criteria over 4 columns.

In another sheet I wish to lookup that all four aspects match, but where blank I would like to find “any”. the first column is numerical and the other 3 are text, can you assist?

I have tried concatenating both and using wildcards but they turn to text and don’t work. Equally I can not get Index match arrays to do the job either 🙁



By: Janine

Leave a Reply

Your email address will not be published. Required fields are marked *