 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Simple way to explain.
I have a list with 'Tom', 'Dick', 'Harry'.
In another list I have long text which may have "On Tuesday 27th May, Tom caught a bus with Dick and Harry".
If I wanted .xlsx to identify any cell where 'Tom' was included, how could I do this.
In the real world I have a list with manufacturer part number and trying to figure out whether it exists within our inventory system...where the manufacturer part number may be embedded within long description.
Thanks!
Could you use VLOOKUP with the range lookup set to True?
going to do this more than once? Sort out the data properly
You can use the FIND function.
For example =IF(FIND("Tom",A1,1)>0,"Tom","Not Tom")
It'll be format conditioned to "white" 😆
=ISNUMBER(SEARCH([search text],[full text]))
So, have your long text in column 1, then Tom in column 2, Dick in 3, etc.
Once these columns are filled, in the next columns use the above formula as such:
=ISNUMBER(SEARCH(B1,A1))
=ISNUMBER(SEARCH(C1,A1))
=ISNUMBER(SEARCH(D1,A1))
Edit: use FIND instead of SEARCH if you need to be case-specific
Wouldn't a database be a better solution for stock control?