I think you would need to post a sample so we can see the data types in play etc... does the same VLOOKUP entered natively return expected results ? ie

Z4: =VLOOKUP(C4,Sheet2Name,11,0)