Hi,
I've been trying to write a formula to return a yes or no if part of a cell contains a value stored in a separate cell (B1 in this case).
Ive tried =IF(ISNUMBER(SEARCH(d1,A2)),"Yes","No")
But obviously that will probably look for an entire match. Whereas I have data like this
A B 2014/09/01 2014/09/02 testing false 2014/09/01 testing true
Where data in column A has other data included. Any help you guys can offer would be v. much appreciated
Last edited by BPSJACK; 09-05-2014 at 11:48 AM.
Formula:
Please Login or Register to view this content.
Your formula checks for part of the cell as well.
________________________________________________________
If your problem is solved, update the thread as SOLVED: Go to the top of the first post-Select Thread Tools-Select Mark thread as Solved OR - Go to the first post - Click edit- Click Advance- Just below the word "Title:" you will see a dropdown with the word No prefix.- Change to Solve- Click Save.
Show your gratitude to the person who helped you solving your problem by clicking on star button at the bottom of such post.
That is fantastic you have saved me so much work! Thank you
You are searching a text string for a value Excel is recognizing as a date (and therefore a number).
Try this:
Cheers,
Please Login or Register to view this content.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
So in my testing, the proposed IF using SEARCH worked perfectly.
....Of course, I had to force the reference value to be input as a text string, rather than be automatically converted to a serial number (41883 for 1st Sept. 2014), so that might cause you trouble...? Well, without knowing more about your data structure, that might or might not be a problem.
Thanks for the advice, I've updated the formula accordingly and it works like a charm.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks