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

Here is what it would look like.

http://screencast.com/t/GmGlcy3vv
frugalmuleAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GaryCommented:
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 ????
0
frugalmuleAuthor Commented:
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.
0
GaryCommented:
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...?
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

frugalmuleAuthor Commented:
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.
0
GaryCommented:
No attachment
0
frugalmuleAuthor Commented:
Sorry, just posted it.
0
frugalmuleAuthor Commented:
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.
0
GaryCommented:
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...
0
frugalmuleAuthor Commented:
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.
0
frugalmuleAuthor Commented:
Here is an updated sheet with most extensionsEnter-an-Extension.xlsx and cube numbers which will change and be added to.
0
Brian TaoSenior Business Solutions ConsultantCommented:
Why don't you just put the lookup table (I assume it be an Excel file) to the public file share?
0
frugalmuleAuthor Commented:
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
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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'.
0
frugalmuleAuthor Commented:
Latest revision 40521353.  It should be clearer now by looking at the file, what I am trying to accomplish.
0
Ray PaseurCommented:
One of the problems with this application is that the data in column "E" (named "Ext") is not unique.  So if someone typed "Supervisor" what would you give back?

1363-B1D Blue                  654      Supervisor      
1256-B1A Blue                  655            
TR100-C4D Blue                  656      Trainer      
TR099-C4D Red                  657      Trainer      
TR098-C4D Red                  658      Supervisor      

Applications like these typically use database driven web scripts, and have some sets of rules for dealing with duplicate row keys.  I think trying to do this with HTML may be difficult.  You may be able to get some results with JavaScript and HTML.  But I think this may be like using a wrench to drive nails.  HTML by itself is not the right tool for the job.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
frugalmuleAuthor Commented:
Ok, can we get it to happen in Excel only with a simple formula and without custom coding?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.