drop down list selection trigger formula

[oddworld]

hi all i have a travel sheet, in column f a user selects an entitlement component from a drop down list ( between row f10 - f22). Breakfast, lunch or dinner, in column g i manually pull down the formula =SUMIF($N$3:$N$14,F10,O3:O14) to row 22, in column h i manually pull down =IFERROR(VLOOKUP(F10,$N$26:$O$29,2,0), "")*G10 to row 22. is there a way that once a user selects a value from column f (the value is not important) to then auto populate the 2 formulas from above into the relevant row in columns.

 

[Dave87]

in Cell G10 paste
=IF(ISBLANK(F10),"",SUMIF($N$3:$N$14,F10,O3:O14))
then drag it down to row 22

in cell H10 paste
=IF(ISBLANK(F10),"",IFERROR(VLOOKUP(F10,$N$26:$O$29,2,0),"")*G10)
then drag it down to row 22

now cells G10:H22 should only populate if there is a value in column F