The Paste Special method allows you to manually copy formatting from source cells and paste it into the cells where VLOOKUP results are displayed without altering the data.