I'm trying to find the correct formula to apply to a regualry used Spread Sheet, where i can apply a Formula that can find a value in Column P (Unit of Measure) & conditionally Replace the Value in Column J (Product Code), but where several different product codes are used & require this application.
Something like with direct reference to my specific Spreadsheet:
IF Column P = MT, Replace Column J (with original value +M (eg. ODV050 with ODV050M))
Unable to set formula to recognize the different Product Codes & set the 'M' definition across multiple codes (ODV040 - ODV040M, ODV050 - ODV050M, ODV065 - ODV065M, ODV090 - ODV090M & ODV100 - ODV100M) when Column P = MT.