Vlook up not capturing all numbers

[fireguy7]

Hello - this one just has me stumped and it has to be simple.

I have a workbook with 2 sheets

Main Sheet
School Codes

I'm just trying to do a basic Vlookup to compaire the two sheets.

The Issue = Numbers are in Column A on both Tabs but the Vlook up is still returning #N/A for the last 20 or so.

I've attached an example with PII removed so please point out my stupidity.

thanks.

[Norie]

You have spaces after the School Codes in column A on sheet 'Main sheet'.

[rcm]

to get rid of spaces I suggest to insert the formula in column C of school codes =trim(a...) copy and paste values into column a . also there are codes that do not exist in the list

[fireguy7]

I was actually just being dumb - it was trailing spaces on the numbers that was causing them not to show. A simple Trim formula fixed the problem.

[martindwilson]

select column A /data /text to columns /fixed width ,click next click next again ,choose text from column data format, click finish
or select from a2 to a162 find space replace with nothing
or
use
=VLOOKUP(TRIM(A2),'School codes'!A:A,1,FALSE)