Excel Vlookup problem

[beaniebear]

I have three worksheets that I am amalgamating into one master worksheet using vlookups. In each worksheet there is an employee number which take the format of '0' followed by 6 other numbers. I pull the employee number from one of the worksheets by doing a direct reference to it. The rest of the information is then pulled in using vlookups. The problem I am having is that it is not pulling in all of the information. I have made sure the cells are of the same format, but it is matching some and not others. Any help would be much appreciated.

 

[KenWright]

Post your formula, and explain what you are seeing as opposed to what you expected to see.

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------