E.G. look for value in cell a1, look for it in colum C and return true if found or false if not foundExcel excel - how do i look up a value in one cell and have return a true or false ?
=ISNUMBER(MATCH(A1,C:C,0))
Match looks for A1 in column C. If it finds a match it returns the row number of the matched cell.
ISNUMBER evaluates what Match returns. If Match returns a number, ISNUMBER returns TRUE. If Match finds no match, then ISNUMBER sees no number and returns FALSE.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment