software

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 quot;yesquot; and if it does not quot;noquot;.

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 quot;yesquot; or quot;noquot;,
but it was only checking if the cell I specified equaled another
specified cell.--
Wheezl
------------------------------------------------------------------------
Wheezl's Profile: www.excelforum.com/member.php...oamp;userid=34684
View this thread: www.excelforum.com/showthread...hreadid=544491There 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)),quot;noquot;,quot; yesquot;)

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)gt;0,quot;yesquot;,quot;noquot;)

copy downRegards,Peo Sjoblom

quot;Wheezlquot; wrote:

gt;
gt; I am very new to Excel functions and I can not figure out how to do
gt; this. I have a column of numbers in A (sheet 1). I want to have column
gt; B have a function that takes the number value from each cell in column A
gt; (sheet 1) and checks if that exact value exists anywhere in column A
gt; (sheet 2). If the number exists in any cell in column A (sheet 2) I
gt; want the cell to display quot;yesquot; and if it does not quot;noquot;.
gt;
gt; I figured out how to have Column B check to see if Column A equals the
gt; value ONE CELL, but not if that value exists anywhere in a range of
gt; cells. I successfully used the IF statement to return quot;yesquot; or quot;noquot;,
gt; but it was only checking if the cell I specified equaled another
gt; specified cell.
gt;
gt;
gt; --
gt; Wheezl
gt; ------------------------------------------------------------------------
gt; Wheezl's Profile: www.excelforum.com/member.php...oamp;userid=34684
gt; View this thread: www.excelforum.com/showthread...hreadid=544491
gt;
gt;


Nnnnnnnnnnnnnnnnnnnnnnnnnn
Tttttttttttttttttttttttttt--
Wheezl
------------------------------------------------------------------------
Wheezl's Profile: www.excelforum.com/member.php...oamp;userid=34684
View this thread: www.excelforum.com/showthread...hreadid=544491What's this supposed to mean? Did either of the proposed solutions
work?

Pete