VLookup Problem

I am using VLookup the way I have always used it but for some reason the values returned are #N/A
I have a column of numbers in A on 2 sheets and some info on 1 of the sheets that I want to put into column C on the other but #N/A!! Any ideas. Thanks.

  I am Spartacus 15:57 05 May 09

It's possible you have leading or trailing spaces in your values. Try using the TRIM function to remove them click here

  VoG II 16:27 05 May 09

Thanks sorted it now. I copied the info into 2 fresh spreadsheets.

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

VFX Oscar nominees 2017: Discover how the visual effects were created

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…