Column A contains a 7 digit code.
Column B contains a code that could be 1 digit, 2 digits, 3 digits, 4 digits or 5 digits.
Column F contains random Code 2 codes.
The objective is to match the Code 1 from Column A with code 2 from the same row, to the same code 2 in Column F.
This formula worked for another problem but will not work for this problem.