Good afternoon excel guru's,
I have a formula that currently works which looks returns a value based on another cell, as follows;
=INDEX(A:A,MATCH(B2, C:C,0))
My question is how do I add the IF function if I want it to search for values based on certain criteria, e.g. only return values from column A if Column D has "Yes" and Column E has "Apple".
I have a formula that currently works which looks returns a value based on another cell, as follows;
=INDEX(A:A,MATCH(B2, C:C,0))
My question is how do I add the IF function if I want it to search for values based on certain criteria, e.g. only return values from column A if Column D has "Yes" and Column E has "Apple".