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!

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.

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.