Excel and Vlookup help pleeeease

[robisc]

I have 2 columns of data they are in A and C, then in column B I have the Vlookup formula

=IF(ISNA(VLOOKUP(A2,C:C,1,FALSE)),"No","Yes")

This brings back the right results in 1 spreadsheet but when I copy the data from columns in another spreadsheet the results are all "NO" even though there are matches, does anyone know why this is doing this??
Thanks,

 

[robisc]

I forgot to add the fact that the data includes text and numbers, for example:

RA1089163

I don't know if this has anything to do with or not.

Also I can replace the cells (manually) with the exact data that is in there now and the formula works just not with the pasted data.

 

[WW]

do the pasted values have an apostrophe (') in front of them if you look at the cell values? or are they mixed?

try selecting the column (in the spreadsheet that doesn't work), and then Data>Text to Columns and then Finish

 

[robisc]

try selecting the column (in the spreadsheet that doesn't work), and then Data>Text to Columns and then Finish

This seemed to do the trick, thanks.
This must hav been some type formatting issue.