Hello,
I am writing to seek help in implementing the following vba macro logic below:

If column E equals to “Auto”, “RMBS”, “CMBS”, “CLO”, “Student” or “Consumer” then do nothing,
Else
If there is any other value besides the one above THEN change it to “Esoteric”.

I am currently using the following find and replace code below but there are many variations in the large dataset and which is making it hard to manually input in the values into the code. 

Sub find_replace()

Range("E1").Select
    Cells.Replace What:="Future flow ABS", Replacement:="Esoteric ABS", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False
        
    Cells.Replace What:="Infrastructure ABS", Replacement:="Esoteric ABS", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False
End Sub
I have also attached workbook example with the dataset, indicating the yellow highlighted names, need to be changed into “Esoteric”.
example_set.xls

Please Note: the words such as Auto and many more mentioned above are not always in the same position in the cells
.

Any help with this issue, would be a great help.
Thanks in advance for your help and time.