Forum Discussion
Vonni95
Jun 09, 2020Copper Contributor
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...
bhushan_z
Jun 09, 2020Iron Contributor
can u pls share the file?
- bhushan_zJun 09, 2020Iron Contributorcan you remove confidential data and share just some sample?
it is difficult to provide solution just based on info you have provided.- Vonni95Jun 09, 2020Copper Contributor
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.