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 🙁