The original function referenced H8, but after converting the data range to a Table, the function references the last row in the Table, row 9–you didn’t have to update the functions in column E!

Explore table-specific features: Take advantage of Excel’s table-specific functionalities, such as automatic column naming and dynamic range adjustments, to simplify your workflow.

You use these functions when you want to find values based on the value in a corresponding cell. Thanks to the newish dynamic array function XLOOKUP (), you now have more power and less confusion.