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.
Tue, 01/19/2016 - 06:50
#1
VLookup in Microsoft Excel
If you want to hard code the values, select data, copy and paste special, values.
Add new comment