I am using Data Validation / dropdown to allow a user to select either a
static entry or a calculated one.
There is a line of products a1=apple b1=banana c1=cucumber
There is a line of prices a2=35 b2=25 c2=38
There is a 'select price' row.
The user can select from 49, 59, or 'the row above *1.5'
I can create the indirect command =indirect("R[-1]C",0)*1.5 and that works
fine
BUT - I can't get it from the validation list.
The list will only present the VALUE that cell in the validation list
computed - not the formula itself.
I've tried a couple of ways - including using a vlookup, but the problem is
the same. Any suggestions?