Hello,
I need a formula that will:
Refer to a specific cell E1, check if E1 has any value at B column in table "Table1" (A1:B8). In table "Table1", at B column, there are different values (including duplicated values) corresponding to cell E1. If a specific text "Mary" is available, then...