VLookup in Microsoft Excel

2 posts / 0 new
Last post
VLookup in Microsoft Excel

After cross referencing two spreadsheet using VLookup, I deleted the second sheet that had the data for cross referencing, consequently I lost all the information that I compiled in the VLookup column.
Is there any way I could delete the sheet 1 or sheet 2 without loosing the vlookup results? because the spreadsheet I used to look up is so big and I do not want to send that to others due to its size.

Paste Values

If you want to hard code the values, select data, copy and paste special, values.

Add new comment