Please post a sample workbook as, from your description, it is not immediately obvious what you are trying to do ... or what your VLOOKUP formula looks like.

Regards