lookup函数出错

公西不孤

C7公式：=100+ROUNDUP((MIN(C5:C6)-15)/MIN(LOOKUP(C3,{6,7,8,9},{5,4,3,2}),LOOKUP(C4,{6,7,8,9},{5,4,3,2})),0)*50*MAX(LOOKUP(C1,{"框架结构","框剪结构","抗震墙结构"},{1,0.7,0.5}),LOOKUP(C2,{"框架结构","框剪结构","抗震墙结构"},{1,0.7,0.5}))
当C1、C2为"框架结构“”或是“”框剪结构“”时都没问题，一个为“”抗震墙结构“”时就会出错

看见星光

调整下顺序，把"抗震墙结构"放到前面。LOOKUP是这种使用方法要求参数升序排列

=100+ROUNDUP((MIN(C5:C6)-15)/MIN(LOOKUP(C3,{6,7,8,9},{5,4,3,2}),LOOKUP(C4,{6,7,8,9},{5,4,3,2})),0)*50*MAX(LOOKUP(C1,{"抗震墙结构","框架结构","框剪结构"},{0.5,1,0.7}),LOOKUP(C2,{"抗震墙结构","框架结构","框剪结构"},{0.5,1,0.7}))

看见星光

另外公式可以减一下，数组公式：
=100+ROUNDUP((MIN(C5:C6)-15)/MIN(LOOKUP(C3:C4,{6,7,8,9},{5,4,3,2})),0)*50*MAX(LOOKUP(C1:C2,{"抗震墙结构","框架结构","框剪结构"},{0.5,1,0.7}),)

公西不孤

谢谢！所谓升序排列是指，按拼音，“抗”排在“框”前面，“架”排在“剪”前面吗？