I've an excel sheet(Data Sheet) with some device names. The device name will consist of a code. The codes may be either placed anywhere on the string. The codes are listed in the Location sheet. First, i want to find out the location code from the device name based on the matches from Location sheet. Once we find the location code, i can map the location name of Region
Can some one help with a script that can find out the code that is within the device name based on location sheet.
Sample Sheet is Attached. I've highlighted the code in Device name inorder to understand an example.