Hello
My apologies for asking. I feel so stupid but I suppose I have to learn somewhere. Any help would be excellent
I have cells with leading zeros
000004 Hempstead Valley #N/A
000006 Dartford #N/A
000007 Carmarthen #N/A
000009 Ballymena #N/A
000010 Boston #N/A
000012 Wisbech #N/A
000013 Lichfield #N/A
000014 Stamford #N/A
000015 Shepherds Bush #N/A
000016 Braehead #N/A
000020 Balham #N/A
My source data is
000004
000004
000006
000006
000007
000007
000010
000010
000012
000012
000013
000013
000014
000014
000015
000015
000020
000020
My vlookup is =VLOOKUP(A1,Source!A:A,1,FALSE)
But it comes back n/a
I have tried to =TRIM(A1) etc but I lose the leading zeros.
I have attached a sample file
Bookmarks