VLOOKUP

Find an exact match in a table and return a related value from another column.

Practical example

=VLOOKUP(A2, Prices!A:D, 4, FALSE)

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