Using Excel I want to find data which MATCHes EXACT values within columns. Then I want the resulting values to be automatically TRIMmed so I can use them further without worrying about the format.

My data consists of four columns - sequence / values1 / values2 / result (being the formula)

This is it when the formula column is added

A B C D
1 1 one one
 =IF(EXACT(TRIM(B1),(TRIM(C1))),"TRUE","FALSE")
2 2 two two
 =IF(EXACT(TRIM(B2),(TRIM(C2))),"TRUE","FALSE")
3 3 three three
 =IF(EXACT(TRIM(B3),(TRIM(C2))),"TRUE","FALSE")
4 4 four for
 =IF(EXACT(TRIM(B4),(TRIM(C2))),"TRUE","FALSE")
5 5 five five
 =IF(EXACT(TRIM(B5),(TRIM(C2))),"TRUE","FALSE")
6 6 six six
 =IF(EXACT(TRIM(B6),(TRIM(C2))),"TRUE","FALSE")
7 7 oneone oneone
 =IF(EXACT(TRIM(B7),(TRIM(C2))),"TRUE","FALSE")
8 8 twotwo twoten
 =IF(EXACT(TRIM(B8),(TRIM(C2))),"TRUE","FALSE")
9 9 threethree threethree
 =IF(EXACT(TRIM(B9),(TRIM(C2))),"TRUE","FALSE")
10 10 fourfour fourseven
 =IF(EXACT(TRIM(B10),(TRIM(C2))),"TRUE","FALSE")
11 11 fivefive fivefive
 =IF(EXACT(TRIM(B11),(TRIM(C2))),"TRUE","FALSE")
12 12 sixsix sixsixty
 =IF(EXACT(TRIM(B12),(TRIM(C2))),"TRUE","FALSE")

 So, using the above table and formula, the result is thus
A B C D
1 1 one one TRUE
2 2 two two TRUE
3 3 three three TRUE
4 4 four for FALSE
5 5 five five TRUE
6 6 six six TRUE
7 7 oneone oneone TRUE
8 8 twotwo twoten FALSE
9 9 threethree threethree TRUE
10 10 fourfour fourseven FALSE
11 11 fivefive fivefive TRUE
12 12 sixsix sixsixty FALSE