How to match this fields?

-- HikaShop version -- : 3.3.2
-- Joomla version -- : 3.8.6
-- PHP version -- : 5.6

See file img attached

CSV FILE
Column1:
1: "product"
2: "model"
3: "model"
4: "product"
5: "model"

Column2:
1: empty field
2: 24121
3: 24122
4: empty field
4: 24130

CSV HIKASHOP
Column: Product_Parent_ID
1: 0
2: 0
3: 94133
4: 94133
5: 94133

Column: Product_Type
1: Main
2: Main
3: Variant
4: Variant
5: Variant

The MODEL_ID (CSV) Column can matches the PARENT_ID (HIKASHOP) Column. I guess the empty field will be read from Hikashop like a 0.

Regarding the RECORD_TYPE (CSV) column I don't know how to match with the PRODUCT_TYPE (Hikashop) column.
I should replace all words "PRODUCT" and "MODEL" in the specific column, with MAIN and VARIANT but is there a formula in excel to do that?
Any other solution? Consider, my aim is to avoid making changes to the CSV or to do minor changes.