Cell Options / Validation for Budgeting or Forecasting

Have you ever been working on your budgeting or forecasting task, which most of it has more than one options/assumptions. Yes if you use spreadsheet, changing cells already help you a lot, but ever considering a more convenient way and still looking for it ? Well here is your answer, in Microsoft Excel it’s called Validation, in OpenofficeCalc we call it Validity.


By combining with some simple VLOOKUP or HLOOKUP syntax will bring you efficiency just like a snap.



Step 1: After creating your assumption, create the validation / validity

Menu -> Data -> Validation



Step 2: Change ‘Any Value’ to ‘List’


Step 3a: Fill your options



Step 3b: or alternatively choose your options


Step 4: Link your options with VLOOKUP


Well that’s all, need some improvisation for a better appreance

Download this file for above example

Good luck!