software

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

www.contextures.com/xlDataEntry03.html

JaB wrote:
gt; Hi there
gt;
gt; I am currently using an Index/Match formula to match and transfer data
gt; between two tables
gt; {=INDEX(UPRNmatch.xls!Gaz,MATCH(O10047,UPRNmatch.x ls!Match,0),1)}.
gt; This has worked fine, until I added new data to the lookup table which I
gt; copied and pasted from access. For some reason, the same formula that worked
gt; earlier will not match the new data. However, if I type over the data, all
gt; of a sudden everything matches.
gt; Ive checked that the formats are the same, and they are so Im confused as to
gt; why this is happening.
gt; Any ideas?
gt;
gt; Cheers--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html