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..


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

or this one


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:



OzGrid Business Applications

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

thank you! That works GREAT