Having a mind blank!
What would be best way to work out where the info in Col C is / isn't contained in the info in Col B, i.e. to say "Found" or "Not Found" respectively.
But also take into account that
- it is not case dependent
- if Col C is blank, please return: "Blank Anyway"
- IF Col C is not found in Col B, please return "Not Found" (as opposed to an error message)
Actually, this isn't a mind blank - I just can't figure it out!
What would be best way to work out where the info in Col C is / isn't contained in the info in Col B, i.e. to say "Found" or "Not Found" respectively.
But also take into account that
- it is not case dependent
- if Col C is blank, please return: "Blank Anyway"
- IF Col C is not found in Col B, please return "Not Found" (as opposed to an error message)
Row | header-1 | header-2 | WIP |
2 | ABCDEFGH | ABC | Found |
3 | ABCDEFGH | abc | Found |
4 | ABCDEFGH | DEF | Found |
5 | ABCDEFGH | ABCDEFGH | Found |
6 | ABCDEFGH | Blank Anyway | |
7 | ABCDEFGH | BLAH | Not Found |
8 | ABCDEFGH | Blank Anyway | |
9 | ABCDEFGH | Blank Anyway | |
10 | ABCDEFGH | ZZZZZZ | Not Found |
Actually, this isn't a mind blank - I just can't figure it out!