Forum Discussion

Copper Contributor

Jun 09, 2020

Solved

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.

bhushan_z

Iron Contributor

Jun 09, 2020

can u pls share the file?

Vonni95
Copper Contributor
Jun 09, 2020
bhushan_z

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.