FORMULAS or CODING?

[peebee37]

I work in the field using a 'tablet', hoping to use a form so, Is this achievable or am I waisting time on this?

I suppose the best way to describe what we're trying to achieve is ....

Take any on-line shopping company,

1 Pick the product.

2 Choose the range/colour

3 Enter the size.

4 Generate price.

5 Add to basket.

Repeat 1,2,3,4 & 5 until order complete, then view basket.

Basket contains products and cost. ( a list containing the above )


As I can use 'index & match's find a value from the SS price matrix, I'm struggling to 'ADD' more after the 1st value & generate a basket


I assume because I have all of the above this can be achieved via tables, formulas etc


Again thank you for your time and willingness to help

 

[Fluff]

Duplicate to: Formulas & functions from price matrix

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.