Generate a report of price changes.

Mario,

Step 1

Create a new field beside the Price field and call it: (New Price).

Step 2

In the New Price field use https://support.office.com/en-us/article/VLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1 to look into the price updates table and return the price update for each item.

Step 3

Create a new field beside the New Price and call it: (Change).

Step 4

In the Change field compare between the old price and the new price using the equality operator ( = ) to return a TRUE or a FALSE result.

Step 4

Filter the FALSE rows and create a new report from them.