T
Tom
I have two sets of data that I am trying to match up by
cutting and pasting each into one worksheet, then running
the Match function. Both sets of data are numerical, but
stored as text. I cannot get the function to work
correctly & it only seems to match up data from the two
columns that start with a 0. When I F2/double click into
the second set of data, the Match function seems to work
for that cell. Because I am matching a huge amount of
data, going cell by cell is not a good fix. Any ideas
why this may be happening? Thanks
cutting and pasting each into one worksheet, then running
the Match function. Both sets of data are numerical, but
stored as text. I cannot get the function to work
correctly & it only seems to match up data from the two
columns that start with a 0. When I F2/double click into
the second set of data, the Match function seems to work
for that cell. Because I am matching a huge amount of
data, going cell by cell is not a good fix. Any ideas
why this may be happening? Thanks