need a search/find/lookup function
 

I need a function to determine if value "A" exists in range B1:B10. If A
exists in B1:B10, return "C". If A doesn't exist in B1:B10, return "D."

I have tried using lookup, I've tried index and match, I've tried
search/find. I can't make any of those do what I want it to.

need a search/find/lookup function
 

Try something like this...

=IF(COUNTIF(B1:B10,"A"),"C","D")

--
Biff
Microsoft Excel MVP


"Jenn" wrote in message
...
I need a function to determine if value "A" exists in range B1:B10. If A
exists in B1:B10, return "C". If A doesn't exist in B1:B10, return "D."

I have tried using lookup, I've tried index and match, I've tried
search/find. I can't make any of those do what I want it to.

need a search/find/lookup function
 

On Fri, 5 Feb 2010 18:03:01 -0800, Jenn wrote:

I need a function to determine if value "A" exists in range B1:B10. If A
exists in B1:B10, return "C". If A doesn't exist in B1:B10, return "D."

I have tried using lookup, I've tried index and match, I've tried
search/find. I can't make any of those do what I want it to.

Case insensitive:
=IF(COUNTIF(B1:B10,"*A*"),"C","D")

Case sensitive:
=IF(SUMPRODUCT(--ISNUMBER(FIND("A",B1:B10))),"C","D")

--ron

need a search/find/lookup function
 

=IF(COUNTIF(B2:B11,"A")=1,"C","D")

OR

=IF(ISNA(VLOOKUP("A",B2:B11,1,FALSE)),"D",IF(VLOOK UP("A",B2:B11,1,FALSE)="A","C","D"))

OR

=IF(ISNUMBER(MATCH("A",B2:B11,0)),"C","D")


Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Jenn" wrote:

I need a function to determine if value "A" exists in range B1:B10. If A
exists in B1:B10, return "C". If A doesn't exist in B1:B10, return "D."

I have tried using lookup, I've tried index and match, I've tried
search/find. I can't make any of those do what I want it to.

need a search/find/lookup function
 

=CHAR(68-(COUNTIF(B1:B10,"A")0))


"Jenn" wrote:

I need a function to determine if value "A" exists in range B1:B10. If A
exists in B1:B10, return "C". If A doesn't exist in B1:B10, return "D."

I have tried using lookup, I've tried index and match, I've tried
search/find. I can't make any of those do what I want it to.