Hi everyone, I am trying to do a multiple criteria lookup with multiple criteria.
Indeed, I think the tutorial in the following link is useful:
Match two criteria and return multiple rows in excel | Get Digital Help - Microsoft Excel resource
(Using the sample from the above link) BUT sometimes in my case, the Cell G3 and G4 may contain a WILDCARD (*) character.
Once I change it to wildcard character, the array formula suggested by the above link does not work anymore.
Anyone knows how to get this work?
Great great thanks in advance.
Indeed, I think the tutorial in the following link is useful:
Match two criteria and return multiple rows in excel | Get Digital Help - Microsoft Excel resource
(Using the sample from the above link) BUT sometimes in my case, the Cell G3 and G4 may contain a WILDCARD (*) character.
Once I change it to wildcard character, the array formula suggested by the above link does not work anymore.
Anyone knows how to get this work?
Great great thanks in advance.