Link to home
Start Free TrialLog in
Avatar of Ted Penner
Ted PennerFlag for United States of America

asked on

Can I do this in a stand-alone HTML file?

Here is what it would look like.

http://screencast.com/t/GmGlcy3vv
Avatar of Gary
Gary
Flag of Ireland image

There is no correlation as to what the entry is and what the calculation should be
Area can 1,2,3,4,
The cube can be 1-900
Extension can be 1200-1900

So ????
Avatar of Ted Penner

ASKER

OK, I'll work on posting an update tomorrow when I get all the right numbers.  There are 4 areas, about 900 cubes, and about 800 phone extensions with one phone extension per almost every cube.

If I were to paste the lookup table, the phone extensions would be looked up, and to the left would be the rest of the data.
Type a number in cell C2 and have the numbers populate automatically
But you say the figures in the other cells could be anything in the ranges above. How is anyone to know what those numbers should be...?
Enter-an-Extension.xlsxThe attached should give some indication as to what I am trying to accomplish, but not much I guess till I get the exact numbers.  Whatever is to the left of the extension would be filled in.
No attachment
Sorry, just posted it.
If I were to paste the lookup table, the phone extensions would be looked up, and to the left would be the rest of the data, whatever that is, subject to new entries and modifying it constantly to correct the data we have.
So you want to do a lookup based on a column value so what do you mean
Can I do this in a stand-alone HTML file
HTML is just HTML - it has no dynamic nature, it is just plain text.

You could load up the data in an associative array and use JS to filter the rows you want...
Most everything remotely java related is blocked at work so I am working on putting it on a public file share and providing access from work.  I am VERY restricted there so I don't think I can even get access to a web server, but a file share potentially.

Ideally, I would like to create a method for users to input an extension and gain the desired output.

We have office 2007, not 2010, but It does have MS Access, so that might be an option.  Thanks for the assist.
Here is an updated sheet with most extensionsEnter-an-Extension.xlsx and cube numbers which will change and be added to.
Why don't you just put the lookup table (I assume it be an Excel file) to the public file share?
Anyone can do a spreadsheet.  I'm looking to create an interactive web-based solution in hopes that they will hire me to help with some I.T. projects.Enter-an-Extension-v2.xlsx
frugalmule, I don't understand why your question consists of a link to a screenshot and that screenshot has text that explains your question.

If you don't get a lot of response to your question, you may want to re-think your question approach. If you make it as hard as you can for people to help you, then don't be surprised if you don't get a lot of replies.

You could have typed the text explaining what you want right into your question.

You could have posted a screenshot right into your question.

Instead you hide your question in a screenshot and sent us to another site to load it. Why?

Just sayin'.
Latest revision 40521353.  It should be clearer now by looking at the file, what I am trying to accomplish.
ASKER CERTIFIED SOLUTION
Avatar of Ray Paseur
Ray Paseur
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Ok, can we get it to happen in Excel only with a simple formula and without custom coding?