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