Match function problem

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top