Forum Discussion
Setting retrieved data
I understand the need to visualize but I'm afraid all the information is personal contact details. I'm not sure I could anonymize it and still retain the function properly.
Anyway, I don't think this is the kind of question that needs to see the actual data. All I need to know is if ANY kind of data retrieved through a VLOOKUP function can be set (I'm not sure of the proper term) so that it doesn't need to reference the original data any longer. Sorry, that's the clearest way I can explain it.
Here's the way I said it in the file
And here's where you find it in the Edit menu:
And once you select Paste Special you'll see this next choice: Select "Values"
Just to be completely clear: you first select the VLOOKUP cells and do Edit...Copy, then go to the place where the actual values need to be pasted and select Paste Special, etc.
Simple Copy and Paste will produce exactly the problem you're experiencing. It's Copy...Paste Special that you want.
