I am been thinking about how to do this and I am stuck.
I have text in C2 and what I need to do is return a 1 (if the text is found) or blank (if the text isn't found) in D2. The search area is between Q9:105 and AH9:105.
I am been thinking about how to do this and I am stuck.
I have text in C2 and what I need to do is return a 1 (if the text is found) or blank (if the text isn't found) in D2. The search area is between Q9:105 and AH9:105.
Maybe this...
=IF(COUNTIF(Q9:Q105,C2)+COUNTIF(AH9:AH105,C2),1,"")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks