Forum Discussion

Copper Contributor

Jun 09, 2020

Setting retrieved data

With the generous help of someone on this forum (thanks again!), I was able to retrieve some data that had been messed up on my Excel sheet. We used a VLOOKUP function to sync two columns of data tha...

Formulas and Functions

mathetes
Jun 09, 2020
Vonni95

I think the instructions were to use Copy and Paste Special .... Values, putting the correct emails themselves, not the VLOOKUP formulas, into the column where they belong.

Iron Contributor

can u pls share the file?

Copper Contributor

Jun 09, 2020

Nope, sorry, proprietary/personal data.

bhushan_z
Iron Contributor
Jun 09, 2020
can you remove confidential data and share just some sample?
it is difficult to provide solution just based on info you have provided.
- Vonni95
  Copper Contributor
  Jun 09, 2020
  bhushan_z
  
  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.
  - mathetes
    Silver Contributor
    Jun 09, 2020
    Vonni95
    
    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.

Share

Resources