Hi
First post so please forgive me if this is too difficult.
I have a spreadsheet with text in multiple cells in Cols A and B
I want to search for a specific piece of text in Column A
When it finds that text I want to search the corresponding cell in column B to verify if its also there or not
If it is there I want to print a relevant text message to corresponding cell in column C saying 'found' or 'not found'
E.g.
Say text in cell
A1 = /TD_1 is active
B1 = /TD_1 not available
I want to search for TD_1 and verify it matches both cells and output the result found into C1
Is VBA the best way to do this or can anyone help?
I have been searching Regex functions as well but I don't know how to use this properly in Excel
Thank you
Bookmarks