Quote Originally Posted by vicshippers View Post
The source cells are formatted as text.....
Are you sure? If one of the source cells is C2 then what does this formula give you

=ISNUMBER(C2)

If the answer is TRUE then the cell is formatted as a date or number. I suspect the answer will be TRUE because VLOOKUP shouldn't change the result if it's text formatted