Question: how to copy and paste vlookup results?
Answer: For example, if vlookup is in Sheet1 A1 and you are copying it to Sheet2 A1, just type "=sheet1A1" into sheet2 A1? It gets more complicated if you want to put it somewhere else but the principle holds. Use the "copy" function as usual, but use "paste special" (CTRL + Alt + V) and choose values only when you paste it.