Forum Discussion
Extracting data using multiple criteria
Is this possible in "one go" to extract rows from a large excel data set using multiple criteria. I have a long list of companies, and each is - among other things - identified by an industry SIC cod...
NikolinoDE Many thanks for your reply ... however, I found a solution using the XLOOKUP function which - when I inserted a "cheat column" of data in my data set that would be displayed when a value match was found (e.g. a "fake phone number" from the official example/here a "1". The "cheat dataset" is useful for subsequent sorting .. so all well 🙂
- Many thanks, Sergei. Claus