MrExcel Publishing
Your One Stop for Excel Tips & Solutions

IF/LOOKUP function


Posted by joseph scales on March 06, 2001 11:57 AM

I asked this question yesterday and greatly appreciate your response. I think however my question was not very clear. Let me try again. I have the number "1" in cell A1. In cell B1 I want to enter a formula that searches an entire other column (e.g. column c)for the value in cell A1 (1)and return "yes" if the value is anywhere within column c and "no" if it is not found anywhere in column c. I have only been able to make this work if the A1 value (1)was located in C1 rather than C2-C25.


Posted by Michael Saunders on March 06, 2001 12:05 PM

I don't know if this will help

I use a function to search for a given value in a range of cells, if it finds any it counts the amount found..

=COUNTIF(P18:P796,"no")

that will search P18 through P796 and count how many times no is found

or this one

=IF(D19=1,"yes","no")

this looks at D19 if one is found it returns yes
if not it returns no

Hope this helps :-)

Posted by Dave Hawley on March 06, 2001 12:07 PM


Joseph, try this:

=IF(COUNTIF(C:C,A1)>0,"Yes","No")


Dave


OzGrid Business Applications

Posted by joseph on March 06, 2001 1:01 PM

thank you! That works GREAT