Formula Help

[jonoross]

Hi guys

I was wondering if any one knew a formula to search for a specific date in a column and return the value to "Yes" if true?

Example below. I need the formula to search a range of cells and identify 7/12/2021 and return the answer to Yes. Do I use the IF function?

[#2]

@jonoross 

Here is a small example with Yes and No.
Formatted the date cells to text.

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

[#3]

Hi NikolinoDE

Thanks for your response but I require the formula to be able to identify the date from a date range. I have reattached your spreadsheet with an explanation which I hope clarifies what I need.

Thanks heaps for your help!

@NikolinoDE 

[#4]

@jonoross 

Please explain in detail

Week	Date	Day	Starter	Reserves	Overtime
Week 1	12.07.2021	Monday	Yes	Yes	No
Week 1	13.07.2021	Tuesday	No	No	No
Week 1	14.07.2021	Wednesday	Yes	Yes	Yes
Week 1	15.07.2021	Thursday	Yes	No	No
Week 1	16.07.2021	Friday	Yes	No	No
Week 1	17.07.2021	Saturday	Yes	Yes	Yes
Week 1	18.07.2021	Sunday	Yes	No	No

You need in E17 a formula but i can not understand why is a Yes or No in the other dates?

[#5]

@NikolinoDE 

I have added more information on the spreadsheet which I hope clarifies things. Thanks again for helping me out

[#6]

As I understand it, No should then appear in C18 to C23. For you it is sometimes yes and sometimes no, without meaning. It's extremely confusing. Is the yes or no just for the show there, or have I misunderstood something?

[#7]

@jonoross 

Maybe you mean something like this ... example in the inserted file.

regards,

NikolinoDE

[#8 · Accepted solution]

@jonoross 

Hello,
please see the attached file

=IF(COUNTIF($C$2:$C$11;B17)>0;"Yes";"No")

[#9]

Yes what is the formula you used please?

[#10]

Thanks thats the one :) much appreciated

[#11]

=IF($B$1=B16,"Yes","No")

thx

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

[#12]

Thanks Nikolino much appreciated

[#13]

You are welcome. If my answer help you, maybe you can mark it as best response.
BR
Chris

[#14]

yw

[#15]

@German_Chris 

Hi Chris

I also need the formula to show E3="Upper Body". How would I add this into formula =IF(COUNTIF($C$2:$C$11;B17)>0;"Yes";"No")

Thanks

[#16]

Hello,
sorry, I do not understand what you mean with: … to show E3 = „Upper Body“