Forum Discussion

faithpremier's avatar
faithpremier
Copper Contributor
Feb 14, 2023

Using drop down cells in formulas

I am trying to use coverage levels in a drop down box to auto fill in total loss in a chart. So my coverage level in D3 dictates my total loss in V14. I want that number to automatically fill in on D17-D20. I can make a formula to fill in what coverage level is currently selected in D3, but I want all of them to be filled in. Right now I have to manually input the total loss in column D. Is there some way to automate it?

Thanks!

Formulas and Functions

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Feb 15, 2023

    faithpremier Perhaps like this?

     

    =IF(B17=coverage,totalloss,0) where coverage refers to D3 and total loss to V14.

     

    or =IF(B17:B20=coverage,totalloss,0) in case you are working with a modern Excel. This will spill the results into all four cell at once. Make sure that cells D18:D21 are empty though.

Resources