Thanks xlnitwit. I'll give that a try. The contents of the cell is text that I want VLookup to search not a number. It is a Client Lookup User Form i am trying to create.