Replace a formula with it's value - do I need to macro?

Thank god this forum exists, ok ... here goes ...

I have a spreadsheet with 2 columns (let's pretend), the first column uses Data Validation for a dropdown list. The second column contains a formula that references the 1st column and uses lookup:

=IF(A35<>0;LOOKUP(A35;NewCons;NewGroups))

So as soon as a value is selected in column A, column B changes to display a value.

Rather than just displaying this value, I would like the cell in column B to be completely replaced by this value, so goodbye to the formula.

Is there a way that I can do this? Will I need to go and study how to use macros?

Thanks in advance