Forum Discussion
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 Online, cells E7 & E8 seem to work, but cells E20 through G23 don't, simply displaying #N/A. These all work in desktop Excel.
The sheet is operated with the Vlookup (and some other) cells protected. There is no password.
I'd appreciate any corrections or suggestions for alternate methods.
Thanks
1 Reply
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.
