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.

Surface Pro 5 News - release date, UK price, features, specs

Microsoft Surface Studio hands-on review: the iMac killer is here

Best Mac antivirus 2017