XLOOKUP

Use a modern lookup that can search in either direction and handle missing results.

Practical example

=XLOOKUP(A2, Products[SKU], Products[Price], "Not found")

Identify the source cells, apply the smallest reliable formula or tool, and test the result with changed data.