Problem with VLOOKUP

Hi to ALL,

As the title suggests, I have a problem with the VLOOKUP function.

I'm not sure if I can explain this properly, but here goes.

I am using Win XP home with Excel 2000.

I have a spreadsheet named smvbook2007 on my C drive and I am using the following formulas in another spreadsheet named smvewac also on my C drive.



IF(A5="","",VLOOKUP(A5,'C:\[smvbook2007.xls]Sheet1'!$A$1:$G$4999,2,FALSE))

IF(A5="","",VLOOKUP(A5,[smvbook2007.xls]Sheet1!$A$5:$G$4999,4,FALSE))

IF(A5="","",VLOOKUP(A5,[smvbook2007.xls]Sheet1!$A$5:$G$4999,6,FALSE))


The spreadsheet smvbook2007 contains 8 columns and I am lookingup columns 2, 4 & 6.

Column A in both sheets is formatted 000 000 00

Column A in sheet smvbook2007 contains blocks of numbers with the first 3 digits starting, 001, 002, 003, 011, 012, 055, etc.

All the VLOOKUP's seem to work except the ones beginning 001. I have tried retyping some of these numbers. If I delete a 001 number and re-enter it further down the sheet (smvbook2007) it works.

Any Ideas?

TIA
Keith (Cornwall UK)

You could also try the tips on the link

Or if lookup cell formatted as text try

=VLOOKUP(A5+0,

http://www.contextures.com/xlFunctions02.html#Trouble

VBA Noob