find and replace text for another cell?

asked 2018-12-16 15:35:09 +0200

davec gravatar image

Hi Is it possible to search within 1 column in order to change text/number in another column?

I have 4 columns for tshirts (SKU, ASIN, PRICE, QUANTITY) and i need to find ALL the 4/5XL's in column 1, but i want to adjust the price, and this is in column 3. Can this be done please? it seems logical enough but i dont know how to use formulas. I only use the CTRL H for find and replace.

Many thanks David

edit retag flag offensive close merge delete