I have an Excel spreadsheet with a Vlookup, so a person can enter a 4 digit number, and finds a row that has that 4 digit number in column A, and pulls out the associated columns B, C, D, E, and F from that row.
The numbers are NOT sequential, so it’s not as simple as an ordered list.. they’re IDs for items, and can be any 4 digit number.
So for example, I have this (but 3000 rows, and the N/A’s sometimes have values):
0010 2 hrs N/A N/A N/A 1.3G 0012 12 hrs N/A N/A N/A 1.4S 0014 12 hrs N/A N/A N/A 1.4S 0015 2 hrs N/A N/A N/A 1.2G 0016 2 hrs N/A N/A N/A 1.3G 0018 2 hrs N/A N/A N/A 1.2G 0019 2 hrs N/A N/A N/A 1.3G 0020 2 hrs N/A N/A N/A 1.2K
I need to turn this excel spreadsheet + vlookup, into a standalone HTML file that only uses JS (no serverside PHP, database, etc).. so our docks can use their laptops to look up values quick with no net connection. Reason it needs to be HTML, is so we can duplicate it onto our website, but they can save that page and it still works.
Continue reading Need some JS help? Possible paypal reward