Do you know any solution on how I could make my dropdown menus and vlookup functions work on a webpage created from an Excel file?
I used the built-in Save as -> Webpage function of Excel, and also a free online converter, but none of them could make an HTML where dropdowns would work. This is crucial in the Excel file I created, so I would really need this feature. Do you have any idea on how could I create a webpage with this feature?
Should I maybe use PowerBI for this? Is there any FREE option to publish an excel in PowerBI? I need this webpage to be accessible for all, not just in my organisation. I would prefer not to use PowerBI, especially if you have an easier solution.