Hi Cindy,
Provide the code of the macro you are recording, you can find it in the vba ide by typing ALT+F11 and look for the workbook where you have created the macro in the left window and there you should find one or more macro in the module folder. Copy the code where you want to customize the code for your vlookup. Then someone here or me should be able to help.
Pascal Baro