Forum Discussion
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 ...
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.