I am very new to Excel functions and I can not figure out how to do
this. I have a column of numbers in A (sheet 1). I want to have column
B have a function that takes the number value from each cell in column A
(sheet 1) and checks if that exact value exists anywhere in column A
(sheet 2). If the number exists in any cell in column A (sheet 2) I
want the cell to display "yes" and if it does not "no".

I figured out how to have Column B check to see if Column A equals the
value ONE CELL, but not if that value exists anywhere in a range of
cells. I successfully used the IF statement to return "yes" or "no",
but it was only checking if the cell I specified equaled another
specified cell.


--
Wheezl
------------------------------------------------------------------------
Wheezl's Profile: http://www.excelforum.com/member.php...o&userid=34684
View this thread: http://www.excelforum.com/showthread...hreadid=544491