Note, by the way, in the upper left corner of the second screen shot that it has given the table a very imaginative name, Table4, since this is the fourth table I created in the spreadsheet. Naming tables makes it very easy to refer to the contents of the entire table, however big it has grown, which will become important when referencing the table in future uses of it, such as if the table is the basis of a pivot table or a dropdown list.
Now go to cell E4, hit F2 to go to edit mode, and hit enter, and voila, the formula has filled down to all of the rows.
Pingback: Elementor #443 - sparrowsolutions.ca
Pingback: Multiple Criteria Lookup Formula, Or How To Create Complicated Formulas When Required - Sparrowsolutions.ca
Pingback: Excel Power Features To Learn - Sparrowsolutions.ca