Hmmmm Still can't get that to work.....
I have built a ref table:
- service1 10 15
service2 15 20
service3 20 30
service4 25 40
(This covers I4:K7)
But it doesn't seem to want to know.....
Can I not do something like =I((E19="basic",J4)
put the right thing here (E19="Professional",J5)
Edit...
Got it sussed....
=IF((E15="Basic"),D6,IF((E15="Professional"),D7,IF ((E15="Premium"),D8,IF((E15="Customised"),D9,""))) )
.