I wrote this formula on excel to return specific values based on the conditions inputted. However, after writing the formula on google sheets it doesn’t seem to work as it does on excel. It only takes the first condition such as “1”, “LR0”, “C”, etc… but doesn’t read the other “criteria”… Does anybody know why it does not work?