I have two columns. One column has complex labels and the other has simple labels. For example, the complex labels might look like "Complex Label: WORD-12345 Blah blah blah", whereas the simple label would just say "WORD".
If "WORD" is contained in any complex label, I'd like to tag that item. Now, I've tried a formula like this: =IF(ISERROR(MATCH())) , but I can't seem to get it to work with partial values.
I've attached an example file to help make this clearer. Excel Matching Example.xlsx
Like this?
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
in b2
=iferror(LOOKUP(2^15,SEARCH($D$2:$D$3,A2),$D$2:$D$3),"-")
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Perfect, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks