在excel中lookup在0到99中寻找错误的怎么没用 ,b10中无论输入什么东西都是现实“有”,为什么
在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},{"有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","无","无","无","无","无","无","无","无","无","无","无","无","无","无","无","无","无","无","无","无"})