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

There are a number of ways. You could try this, assuming your data in
Sheet2 extends from A1 to A1000, and that the first cell you want to
check in Sheet1 is A1, enter this in B1:

=IF(ISNA(VLOOKUP(A1,Sheet2!A$1:A$1000,1,0)),"no"," yes")

Copy this down column B by double-clicking the fill handle (the small
black square in the bottom right corner of the cursor with cell B1
selected).

Hope this helps.

Pete

=IF(COUNTIF(Sheet2!A:A,A1)0,"yes","no")

copy down


Regards,


Peo Sjoblom

"Wheezl" wrote:


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

Nnnnnnnnnnnnnnnnnnnnnnnnnn
Tttttttttttttttttttttttttt


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

What's this supposed to mean? Did either of the proposed solutions
work?

Pete