software

When using formulas such as VLOOKUP or SUMIF on a spreadsheet we assume has
been exported from an Access database Excel only seems to read so many
characters of the data it is doing the look up on so even though codes are
unique the first few character may be the same so we are not getting true
results.

Is there a way around this? We have tried copying amp; pasting as values etc
with no effect

Thanks

Try adding the quot;FALSEquot; option to your VLOOKUP formulas, as...

=VLOOKUP(A1,MyRange,2,FALSE)

hth
Vaya con Dios,
Chuck, CABGx3
quot;Sharon Aquot; wrote:

gt; When using formulas such as VLOOKUP or SUMIF on a spreadsheet we assume has
gt; been exported from an Access database Excel only seems to read so many
gt; characters of the data it is doing the look up on so even though codes are
gt; unique the first few character may be the same so we are not getting true
gt; results.
gt;
gt; Is there a way around this? We have tried copying amp; pasting as values etc
gt; with no effect
gt;
gt; Thanks

Thanks for that, my MD has just used it amp; it does the job.

quot;CLRquot; wrote:

gt; Try adding the quot;FALSEquot; option to your VLOOKUP formulas, as...
gt;
gt; =VLOOKUP(A1,MyRange,2,FALSE)
gt;
gt; hth
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Sharon Aquot; wrote:
gt;
gt; gt; When using formulas such as VLOOKUP or SUMIF on a spreadsheet we assume has
gt; gt; been exported from an Access database Excel only seems to read so many
gt; gt; characters of the data it is doing the look up on so even though codes are
gt; gt; unique the first few character may be the same so we are not getting true
gt; gt; results.
gt; gt;
gt; gt; Is there a way around this? We have tried copying amp; pasting as values etc
gt; gt; with no effect
gt; gt;
gt; gt; Thanks