Question: how to copy and paste vlookup data?
Answer: Use the "copy" function as usual, but use "paste special" (CTRL + Alt + V) and choose values only when you paste it.