'Indesign - Is it possible to update value in cell when I know ID of the product?

I have a question, my colleague is creating product catalog in our company (in Indesign)

He is updating a version from last year, because we have not much new products BUT all the prices (~7000) are new.

I have never worked with Indesign before, so my question is, is it somehow possible to update OLD prices to NEW prices using ID of products, and the price is always located in the cell next to ID? Please check screenshots.

indesign

This is the table with new Prices, in csv file.

indesign

THANKS for any help.

Nikol



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source