Not finding matching value in vlookup

  • Thread starter Thread starter JBS
  • Start date Start date
J

JBS

I have two worksheets Both contain in column A a list for values starting at
A0000001 and ending at A0012068. I am doing a vlookup from worksheet one to
return values from worksheet two. for some reason the function is returning
#N/A. I think that although it looks like I am trying to lookup A0000001
with A0000001, the function is seeing two different formats.
ie
Worksheet 1 Worksheet 2
column A Column A
A0000001 A0000001
A0000005 A0000002
A0000006 A0000003
A0000004
A0000005
A0000006
A0000007

Thanks
Jill
 
Hi Jill

Show us your formula. Without that is impossible to see what's wrong.

Regards,
Per
 
Back
Top