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.