How to see if a value is found in another range.

Use the formula below to check if a value in a cell is found in a range of cells (can be used across sheets or books):

=IF(MATCH([lookup value],[lookup range],0),"Found","Not Found")