XLOOKUP Specialist Needed
Budget: £10 – £15 GBP
I need help with XLOOKUP to fetch numerical data from a cell.
The cells looks like this:
manufacturer=Behr,enable_googlecheckout=Yes,sale_price=6.990000,price_a=3.550000,price_b=3.550000,price_c=3.550000,price_d=3.550000,price_e=3.550000,price_f=3.550000,traffic_light=Yes,amber_level=10,pack_qty=1,is_pack_qty=No,quantity_dropdown=Yes
The information contained in the cell can vary.
Firstly, I would like to extract the numerical part of the cell "sale_price=6.990000" to a new cell.
Secondly, I would like to be able to replace the value (6.990000) in the original cell with another value stored in its own cell.
The cells looks like this:
manufacturer=Behr,enable_googlecheckout=Yes,sale_price=6.990000,price_a=3.550000,price_b=3.550000,price_c=3.550000,price_d=3.550000,price_e=3.550000,price_f=3.550000,traffic_light=Yes,amber_level=10,pack_qty=1,is_pack_qty=No,quantity_dropdown=Yes
The information contained in the cell can vary.
Firstly, I would like to extract the numerical part of the cell "sale_price=6.990000" to a new cell.
Secondly, I would like to be able to replace the value (6.990000) in the original cell with another value stored in its own cell.