Multiple criteria index match where one criteria is a does not contain

I'm trying to create an index match query that contains three criteria where the first two are looking for a match but the third query is a does not contain. Is it possible to mix match conditions like this?

My current match query is

=MATCH(SUBSTITUTE($C2,"_"," ")&"Consumption",Prices[skuName]&Prices[type],0)

I'm trying to create a condition where I check to cells where the productName column doesn't contain Windows.

Is this possible?

3

1 Answer

Resolved by adding a helper column where I check for presence of value in productName column. Then used a three criteria index match to get the final result

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy