Google Sheets - Return "Yes" or "No" if 3 criteria across 3 different columns ar-CodePudding

I'm wondering if there is a formula that can return "Yes" after searching 3 columns and finding 3 exact matches, or "No" if not.

For example, I'd search Column A for "Lizzie", Column D for "10", and Column E for "Approved" and would like "Yes" returned if all 3 values are found in relevant columns, and "No" returned if only 1 or 2 or less are found

CodePudding user response：

Try use Sheet1!D:D="10" without quotation marks and without ranges like A:A , E:E ... better use A287, E287, D287 and then swipe formula UP or DOWN :

=IF(AND(Sheet1!A:A="Lizzie",Sheet1!E:E="Approved",Sheet1!D:D=10),"Y","N")