Hi All - I would appreciate any support
In one base, I have two tables (Master and Prices).
I have a list of products on the master table with a field (column) named costs, and in Prices, I have Product and new Price fields. I need assistance (not sure if this is possible) with a formula that will help me update the costs in the Master table if the product in the Master table is also available in the Prices table.
Example:
In this example, the Master table will only update products A and C’s Cost fields because it has not picked up a product on the Price table.
This means that in Table 1, product A will change automatically to 150 and C to 250. Nothing will happen to B because there is not a unit for it in Table 2.
Any help will be much appreciated.
Thanks