VLookup Problem

  [email protected]© 14:37 05 May 2009

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 2009

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 2009
  [email protected]© 16:40 05 May 2009

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

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

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

How to update iOS on iPhone or iPad

Les meilleures applications pour enfants 2017