I have two huge excel files, lets call them "to be fixed" and "check". The "to be fixed" contains some suffix that end on "_1" etc. or "[1]" etc. The "check" file, that I want to compare the first file to, only contains "_1" suffixes but SOME mean basically the same. So e.g. ERR_PI[1] is ERR_PI[1] in the "to be fixed" file but ERR_PI_1 in the "check" File and ERR_PVS_H_1 is the same in the "to be fixed" and "check" file.
The final goal is to sort out every entry in "fixing" that isn't in "check". Any good ideas? I used VLOOKUP(x,y,1,TRUE) and FALSE but FALSE doesn't detect the difference in "[1]" VS "_1" etc. and TRUE returns entries that just begin with "ERR_" and calls it close enough.