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.x ls!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

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

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

JaB wrote:
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.x ls!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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html