Monday, February 8, 2010

Excel excel - how do i look up a value in one cell and have return a true or false ?

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.

No comments:

Post a Comment