在excel中lookup在0到99中寻找错误的怎么没用，b10中无论输入什么东西都是现实“有”，为什么=LOOKUP(B10,{0,1,2,3,4,6,7,8,10,11,12,13,15,16,17,19,20,21,22,24,25,26,28,29,30,31,33,34,35,37,38,39,40,42,43,44,46,47,48,49,51

Question

在excel中lookup在0到99中寻找错误的怎么没用 ，b10中无论输入什么东西都是现实“有”，为什么
=LOOKUP(B10,{0,1,2,3,4,6,7,8,10,11,12,13,15,16,17,19,20,21,22,24,25,26,28,29,30,31,33,34,35,37,38,39,40,42,43,44,46,47,48,49,51,52,53,55,56,57,58,59,60,61,62,64,65,66,67,68,70,71,73,74,75,76,77,79,80,82,83,84,85,86,88,89,91,92,93,94,95,97,98,99,5,50,9,90,14,41,18,81,23,32,27,72,36,63,45,54,69,96,78,87},{"有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","无","无","无","无","无","无","无","无","无","无","无","无","无","无","无","无","无","无","无","无"})

Answer 1

看你问了两次,再给你一个简单点的公式,=IF(OR(B10={5,50,9,90,14,41,18,81,23,32,27,72,36,63,45,54,69,96,78,87}),"无","有")