Hello, there are two tables in Excell workbook, two different CSV documents with data :
| product code | product name | product price |
| 101 | Bread | 100,00 |
| 102 | Meat | 600,00 |
| no. | product code | product name | product current price | product new price |
| 1 | 500 | Milk | 100,00 | 150,00 |
| 2 | 102 | Meat | 600,00 | 700,00 |
Is there some way to UPDATE product price column in table Product Price List with values from column product new price from table Main Product Price List ?
After UPDATE was executed, table Product Price List should look like this :
| product code | product name | product price |
| 101 | Bread | 100,00 |
| 102 | Meat | 700,00 |
I know how to write program in C# to UPDATE table, load two different excell csv documents and manipulate data inside to get desired result, but I am interested is there some way to do UPDATE trough some Excell functions, filters , or some internal Ecell script.
All the best,
Željko Peric.

Srinivasan RamamoorthiPosted Nov 6, 2021, 4:22 AM
Manoj DwivediPosted Jun 22, 2025, 7:48 AM
Try VLOOKUP
=VLOOKUP(A2, [Sheet2!$A$2:$B$100], 2, FALSE)Prasad RaveendranPosted Jun 21, 2025, 11:23 PM
I would say utilize AI tools like ChatGPT or Copilot to grab the code for spreadsheet update
mohd kaifPosted Jun 19, 2025, 11:56 AM
Thanks for the related information
anh davidPosted Apr 27, 2024, 4:37 AM
You can see the solution at the website: https://tinhoc39.com/