Im sure this question is elementary...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wheezl - 23 May 2006 00:05 GMT

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.

Signature

Wheezl

Reply to this Message

Pete_UK - 23 May 2006 00:21 GMT

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

Reply to this Message

Peo Sjoblom - 23 May 2006 00:21 GMT

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

copy down

Regards,

Peo Sjoblom

> 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
[quoted text clipped - 8 lines]
> but it was only checking if the cell I specified equaled another
> specified cell.

Reply to this Message

Wheezl - 23 May 2006 00:43 GMT

Nnnnnnnnnnnnnnnnnnnnnnnnnn
Ttttttttttttttttttttttttt

Reply to this Message

Pete_UK - 23 May 2006 01:10 GMT

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

Pete

Reply to this Message