If cell X matches a value in a cell range, return "specific text" - HELP :(

Hi helpful community,

I have lost days and gained grey hair in an effort to overcome what i am sure is a simple excel challenege; please help!

My challenge:

Cell J12 is a fixed date (1/1/13)
Cell L13:L112 contains blank cells and various dates
I need Cell J14 to return specific text (in my case "CRM Event") if cell J12 (the date) matches any of the dates in cell L13:L112

Can you help?

Hi Jeff,

Formula solved! Thank you so much!

I commtited myself to a food strike until I figured out this formula; you just saved me a possible silly death!

Thanks again,

Greatly appreciated

Paul

Thank you Moo!

Also works - brilliant!

=IF(COUNTIF(L13:L112,J12)),"CRM Event","")

Thank you Teethless mama - much appreciated

Hello,
I'm looking for something similar, but, what if i would like to have the returned rezult another cell-content and not txt "CRM Event"?
For ex:
I have product_name (cell A1). On the same row I have Price1 (Cell D1)+Provider1(cell E1), then Price2(H1)+Provide2(I1), then Price3(K1)+Provider3(L1) etc.
on C1 i want to have the lowest price. This is done with min (D1,H1,K1,.....)
But on B1 i want to have displayed the associated Provider_name, based on result from C1.

I did something like:
on b1: if (c1, if(c1=d1,e1,)&if(c1=h1,i1,)&if(c1=k1,l1,),0)
But this is a very rudimentary solution and will have to consider the all specific price and provider cells (i.e. over 100 providers), so will take an eternity.
I need something where can be use array concept ....
Thanks

HI,
Apology. I was considered that somehow the opened topic is pretty much related with mine, only that in my case, the aspect is getting a little more complex.