IF函数搭配LOOKUP函数如何筛选多个不同条件?
发布网友
发布时间：2022-04-23 23:14
共1个回答
热心网友
时间：2023-10-13 07:34
看得头皮发麻，看看这个：
=IF(B7="大客",IF(E7="账期内","正常发货",(LOOKUP(O7,{0,6,15},{"暂停发货","授信发货","正常发货"}))),IF(B7="公立",IF(E7="账期内","正常发货",(LOOKUP(O7,{0,9,23},{"暂停发货","授信发货","正常发货"}))),IF(B7="民营",IF(E7="账期内","正常发货",(LOOKUP(O7,{0,9,23},{"暂停发货","授信发货","正常发货"}))),"")))
看我是怎么再嵌个“零售”：
=IF(B7="大客",IF(E7="账期内","正常发货",(LOOKUP(O7,{0,6,15},{"暂停发货","授信发货","正常发货"}))),IF(B7="公立",IF(E7="账期内","正常发货",(LOOKUP(O7,{0,9,23},{"暂停发货","授信发货","正常发货"}))),IF(B7="民营",IF(E7="账期内","正常发货",(LOOKUP(O7,{0,9,23},{"暂停发货","授信发货","正常发货"}))),IF(B7="零售",IF(E7="账期内","正常发货",(LOOKUP(O7,{0,9,23},{"暂停发货","授信发货","正常发货"}))),""))))
