I have a table which looks something like this in Google Sheet:
I want to add a C column which will show the distribution: IF A2 = 'Others', look in B2 for the value. B2= Manufacturing, hence in C2 it is updated to "Manufacturing" IF A3 = 'Manufacturing', Update C column to Manufacturing If A4="Others", B4="Others", update C4 = "Others" If A5= "Others", B5="", update C5="Others
There are actually around 100s of unique values in A column in original sheet and I got successful in updating C column based on just column A. Most of the values in C column are updated to 'Others' and we need to know what is in Column B for the same. I have used the following formula: =IFS(ISBLANK(A2),"",OR(A2="Manufacturing",A2="Manufacturer),"Manufacturing" ,OR(A2="Others",A2="Other),"Others"