Use php to get data out of a excel worksheet based on 2 values -

Use php to get data out of a excel worksheet based on 2 values -

i have excel sheet looks :

vr600 vr700 vr800 vr900 -------length vr600 65 68 70 73 vr700 68 70 72 76 vr800 71 74 76 80 vr900 73 76 80 81 vr1000 76 79 81 84 vr1100 80 82 85 87 vr1200 82 85 87 91 vr1300 83 86 91 97 vr1400 87 90 97 102 vr1500 90 93 102 108 height

now have website 2 combo boxes, (now multiplies 2 values) http://robabny94.ninetyfour.axc.nl/pechhulp/testprogramma.php when length , height in combo boxes filled homecoming right value. looked if figure out kind of formula numbers seems rather random

just cant figure out way working.

thanks in advance help!

edit : if helps set info mysql or , possible

cheers

i'm not @ familiar php, in case may read / write via php excel - next formula provide desired result based on height , length input (assuming construction in initial input):

=index($b$2:$f$11,match(h2,$a$2:$a$11,0),match(i2,$b$1:$f$1,0))

first match height, sec length.

sample image:

sample file: https://www.dropbox.com/s/ed16km08ikhh68f/lengthheightmatch.xlsx

php excel