Find some values that won't VLOOKUP properly and put them into a sample book along with data that does work, post that up here. Maybe we can spot it by looking at it.