Excel Table For Web Site

Struggling with multiple look ups

[oldruts]

Track Width 50 75 100 125 150

drop upto 60" 60.01 73.64 98.21 22.72 147.3
drop upto 80" 73.35 87.52 116.7 145.87 175.05
drop upto 100" 83.6 101.37 135.2 168.99 202.8
drop upto 120" 94.85 112.27 149.7 187.12 224.55

Enter Details
Width
Drop

Price

Can you please help me? I am trying to figure out how to do a lookup with this data.
If you were to add a value into the bold boxes (width and drop) I want a formula which looks up
the relevant price.
for Example if you were to type 65 in the width box and 72 in drop I would like 87.52 to come up as the price.
I'm struggling to work out the function I need.

Thanks

[webdoctor]

I'm struggling to work out the function I need.

Are you trying to make this lookup work on a website, or are you asking for how to do it in an Excel spreadsheet on your PC?

[oldruts]

Eh ok, I am only asking for advice regarding converting excel into a web form. Sorry if I have done something wrong

[benihana]

i think the issue is with 'Click here to install the Office XP Web Components.'

most people wont. they will leave.

[webdoctor]

Any advice greatly appreciated

Don't do this by writing it in Excel and trying to convert it to a web page.

We need to know what type of scripting you are planning on using for this (interactive) page. Are you running Windows/Linux? Are you using PHP? Are you planning on holding your prices in a database or hard-coding them in to your script?

Excel is simply *not* the technology you should be using for your page - it's for spreadsheets, not webpages. Start over from scratch and spend a moment considering the right technologies for the job.

[oldruts]

Thanks for your advice I realise I am trying to use the wrong tool for the job, I have enlisted a friend of mine who is a PHP whizz, hopefully that will solve the problem.

Thanks again!