I'm looking for some help - I have a cross reference pricing table which based upon the selection will give a price.
What I would like is to enter the criteria in a number of selection boxes and for it to lookup the correct price. i.e. in the boxes I would have selected the criteria in green from a 3 drop down boxes and it would have given the price in red.
<tbody>
</tbody>
Can anyone help?
Thanks in advance.
What I would like is to enter the criteria in a number of selection boxes and for it to lookup the correct price. i.e. in the boxes I would have selected the criteria in green from a 3 drop down boxes and it would have given the price in red.
Payment | Product 1 | Product 2 | Product 3 | |
Method 1 | Employee | £4.90 | £7.95 | £9.70 |
Method 1 | Employee & Partner | £9.80 | £15.90 | £19.40 |
Method 1 | Single Parent Family | £8.35 | £13.50 | £16.50 |
Method 1 | Family | £13.25 | £21.45 | £26.20 |
Method 2 | Employee | £6.00 | £9.70 | £13.55 |
Method 2 | Employee & Partner | £12.00 | £19.40 | £27.10 |
Method 2 | Single Parent Family | £10.20 | £16.50 | £23.05 |
Method 2 | Family | £16.20 | £26.20 | £36.60 |
Method 3 | Employee | £8.20 | £8.70 | £17.85 |
Method 3 | Employee & Partner | £16.40 | £17.40 | £35.70 |
Method 3 | Single Parent Family | £13.95 | £14.80 | £30.30 |
Method 3 | Family | £22.15 | £23.50 | £48.10 |
Method 4 | Employee | £8.20 | £8.70 | £17.85 |
Method 4 | Employee & Partner | £16.40 | £17.40 | £35.70 |
Method 4 | Single Parent Family | £13.95 | £14.80 | £30.30 |
Method 4 | Family | £22.15 | £23.50 | £48.10 |
<tbody>
</tbody>
Can anyone help?
Thanks in advance.