Making Data Permanent

I've been using the function =vlookup(...) to help me fill up the cells in my spreadsheet. However, a problem I've come across is that vlookup does not make the values in the cell permanent and keeps drawing whatever value is found in the corresponding cells it searches. Thus if the file it draws it's info from goes missing or is edited, my data also changes accordingly. Therefore I would like to ask if there was a way in which I can make the data permanent in my spreadsheet.

Thanks in advance.

1) Highlight the data you would like to "flatten"
2) CTRL-C to copy it
3) Select Edit > Paste Special > Values and click OK

Done.


NOTE:

Your thread is mistitled. This is not a VLOOKUP question. Consider writing your titles AFTER you write the content of your question.

Maybe: "Make data permanent...remove formulas"

The point of good titles is that most people use this forum to SEARCH for their own answers, the titles are critical to drawing attention to the actual topic.