Find any text in Excel. Instead of manually counting how often a certain value or number appears let Excel do the work for you. What to Know To create a formula with references highlight the cells you want to use then select an empty cell and enter the formula.
AND returns either TRUE or FALSE.
The formula then matches the value in the same row in the result vector column C. Active 3 years ago. In Excel you need to find the position of a text. Because Mary is in row 4 LOOKUP returns the value from row 4 in column C 22.