I have 2 columns to compare,each text. doing formulas, they don'.

  • Thread starter Help with Match function & cell formats
  • Start date
H

Help with Match function & cell formats

I am trying to compare two columns of data with the match function. The
values are the same, but it seems as if the formatting is different because
the match doesn't find the matched data. I have chosen "format Cells" and
made sure both are a text format, but it doesn't seem to affect the format.
When doing the match, the first column displays as "1066", the second as
1066. Can someone help?
 
M

Max

Some thoughts ..

Copy an empty cell and do a paste special > add > ok
to the entire range of text numbers to coerce these to real numbers

One other alternative would be to use something like
=MATCH(TEXT(A1,"0000"),...,0)

instead of
=MATCH(A1,...,0)

to convert the lookup values' real numbers (say)
to match with the reference column's text numbers (say)
 
Top