Forum Discussion
Bob_Griffin
Mar 15, 2020Copper Contributor
Vlookup in Excel Online
I have deleted the attachment due to concerns about it having real information. I will look to create a sanitized version. I have a spreadsheet (attached) with several Vlookup formulas. In Excel O...
mathetes
Mar 15, 2020Gold Contributor
I don't have a solution for you. I do have a recommendation, however: it looks very much as if you have uploaded a file with real information on real vendors, perhaps a real person or two. In general the expectation here, since it's a very public site, is that example files should be rendered anonymous, with a few dummy records (just change names, addresses, etc (other identifiable data elements), giving enough such data elements as will allow testing of the various functions)....
So it would be prudent for you to delete that original file and replace it with a more anonymous one. In the process, since we're just trying to debug, may I suggest that you remove the protection as well.