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