How do you search an entire column with an if statement?

**pitufo** · 05-04-2010, 02:15 PM

I have an if statement that says... if cell A1 is equal to anything in column J, then print "Yes".

Column J has 150 different variables in it, how do I create this "If" Statement?

Thank you!

**NBVC** · 05-04-2010, 02:21 PM

=IF(ISNUMBER(MATCH(A1,J:J,0)),"Yes","No")

**pitufo** · 05-05-2010, 01:44 PM

Thank you for your help! It worked great!

Here is another thing I am now trying to do...not even sure if it is possible with excel.

I want to sift through a column for the word yes... and if the word is yes I want the stock symbol that it relates to.... the stock that is in the same row, just the next column over, to pop up in another work ship in slot A1.... I then want that stock symbol to stay there for 15 seconds even if the word yes has disappeared from the first work sheet.

If there is another yes that comes up next in the orgininal worksheet, I want it to pop into column A1 replacing the old stock.... I want the old stock to then move to B1...

Both will disappear after 15 seconds.

So basically every time a yes appears in a column... that stock symbol will appear in another work sheet and create a list that moves if there are any new symbols with in 15 seconds.

Do you know if this is even doable? Is it doable without the 15 seconds? Thanks a ton for your help!

**pitufo** · 05-05-2010, 01:45 PM

I want to sift through a column for the word yes... and if the word is yes I want the stock symbol that it relates to.... the stock that is in the same row, just the next column over, to pop up in another work ship in slot A1.... I then want that stock symbol to stay there for 15 seconds even if the word yes has disappeared from the first work sheet.

If there is another yes that comes up next in the orgininal worksheet, I want it to pop into column A1 replacing the old stock.... I want the old stock to then move to B1...

Both will disappear after 15 seconds.

So basically every time a "yes" appears in a column... that stock symbol will appear in another work sheet and create a list that moves if there are any new symbols within 15 seconds.

Do you know if this is even doable? Is it doable without the 15 seconds? Thanks a ton for your help!

**NBVC** · 05-05-2010, 01:54 PM

The timing part requires VBA automatically.. Excel native functions can't control automation....

You can list the Last and Second last "yes's" an its corresponding row partners, in another workbook if that is what you are asking, that will change only when adding/deleting yes's from the original.

It you need the timing part, then repost in the Programming forum.

**NBVC** · 05-05-2010, 01:55 PM

This part is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.