Two Sheets: UTI List and Sheet 1
The VLE location in the UTI list mentions in detail the entire addresses with the district names.. all in a single text box. The Sheet 1 mentions all districts to take as reference
I want to:
1)In the VLE Location column, extract the districts into a new column next to the address, if the district names mentioned inside the boxes, match exactly with any district in Sheet 1.
2) Highlight cells that dont match in red
If possible; the cells with text that match closely with the districts, highlights in yellow
Solved by K. U. in 15 mins