pathum kalhan wrote:I am very new to this spreadsheets.
Read
[Tutorial] Ten concepts that every Calc user should know before proceeding further.
pathum kalhan wrote:My goal is replace id_old with id_new in the subcategory_list file. … Any article?
[Tutorial] VLOOKUP questions and answersThe task will be easier if you copy (temporarily) the replacement table from the category_list file into the subcategory_list file. You'll use VLOOKUP to create a new column new_category_id. Then, select these cells. Edit → Copy. Edit → Paste Special →
☐Paste All →
☑Text → OK. This converts the VLOOKUP formula to text. Now you can delete the category_id column.
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6. The locale for any menus or Calc formulas in my posts is English (USA).