I use vlookup all the time, but from your description of the situation, it did not appear to be a solution. Remember, you did not supply a sample document and outlined your issue in writing.

Glad that you have solved your issue. Suggest you mark this as solved.