Matching problem

[Guest]

Hi there

I am currently using an Index/Match formula to match and transfer data
between two tables
{=INDEX(UPRNmatch.xls!Gaz,MATCH(O10047,UPRNmatch.xls!Match,0),1)}.
This has worked fine, until I added new data to the lookup table which I
copied and pasted from access. For some reason, the same formula that worked
earlier will not match the new data. However, if I type over the data, all
of a sudden everything matches.
Ive checked that the formats are the same, and they are so Im confused as to
why this is happening.
Any ideas?

Cheers

 

[Debra Dalgleish]

Number in Access may have been pasted as text in Excel. To fix the data,
you can use one of the techniques shown here:

http://www.contextures.com/xlDataEntry03.html