Vlookup Issue

[Beachson]

I am trying to do a Vlookup between two reports, here is my formula ...

=Vlookup(A2,Sheet2!$A$2:$B$1000,2,0)

I know for certain that there ar exact matches (i.e. "S0001" is on both sheets) but it will not return what is in Column B even though they are exactly the same.

One file is CSV and one is XLS. I have tried everything but cannot figure out why these two cells will not consider eachother a match (Frustrating) please help if you can thanks .

 

[Beachson]

If I took to cells that contained "S0001" and they were formatted differently and would not match eachother in a vlookup how do I make them both the same on another spreadsheet. I have tried formatting before pasteing, pasteing values only saving in different formats but they never match unless I manually type over one of them...then they match

 

[tushiroda]

can only guess that you have a space (one or more) or even tabs in either one or both of the files. you can click into both sides and see if that is the case.

If that is indeed the case, you can use the TRIM function or use text to columns to remove the extras and give the vlookup another try.