Hi.
I'm making codes and descriptions for a list of products, the code and description is based on the product details (detailed in the following columns).
Im using the CONCATENATE formula, the problem is some of the columns are not required for every item, but if I leave it blank the answer shows #N/A.
Using =IFS(ISBLANK worked for the negative, but I need something for the positive.
https://www.mrexcel.com/forum/excel...a-oposit-isblank-post5123578.html#post5123578
I'm making codes and descriptions for a list of products, the code and description is based on the product details (detailed in the following columns).
Im using the CONCATENATE formula, the problem is some of the columns are not required for every item, but if I leave it blank the answer shows #N/A.
Using =IFS(ISBLANK worked for the negative, but I need something for the positive.
https://www.mrexcel.com/forum/excel...a-oposit-isblank-post5123578.html#post5123578