Hello all,

Not sure if this is possible without any scripting or not, but worth a shot -

We have a cost calculator we use for pricing up the machines we build

e.g you type in the sizes of the machine, and it gives you a cost price in another cell along with various other options. We generally have a L x W and number of stations in the machine

What I am after is to dynamically produce a full price list for easy print outs and updating

So I am after some sort of function to do the following -

Display value A1 would show (RRP), when A2 is say 1 (station), then in the next row display A1s value if A2 was set to 2 and so on

All this must be independant of what I type in in A2 when experimenting with different options for customers etc - this is just for a price list

Hope that's clear enough

Many thanks,

Kyle