如果没有特殊的要求,一般对查找区域进行绝对引用,可以有效避免拖动公式带来的数据报错。
查看答案
There is no evidence ______this house price will come down in the short time.
A. which
B. that
C. where
D. as
想精确查找则VLOOKUP函数的第四个参数为TRUE。
A. 对
B. 错
It was not such a good job_______ she had read about in the advertisement.
A. like
B. which
C. as
D. that
在使用VLOOKUP函数时,返回值的列编号可以用字母表示。
A. 对
B. 错