=AND(VLOOKUP(G68,wip!$C:$V,18,0),VLOOKUP(F68,wip!$E:$V,16,0))什么意思
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/04 21:30:55
![=AND(VLOOKUP(G68,wip!$C:$V,18,0),VLOOKUP(F68,wip!$E:$V,16,0))什么意思](/uploads/image/z/13954795-43-5.jpg?t=%3DAND%28VLOOKUP%28G68%2Cwip%21%24C%3A%24V%2C18%2C0%29%2CVLOOKUP%28F68%2Cwip%21%24E%3A%24V%2C16%2C0%29%29%E4%BB%80%E4%B9%88%E6%84%8F%E6%80%9D)
x)us
p7),PTqR 11ԁɹ\rf@9'xaMR>M/X}ﳩy,5
`Ίpπg>ٱOypY-O;?^tΧ <_(d>mأtBϳ۟N{9w0EOva/g{>Ov遝+P+%@5@<ٱb糎 Ww?ٱ+$(hDz@r v/.H̳
=AND(VLOOKUP(G68,wip!$C:$V,18,0),VLOOKUP(F68,wip!$E:$V,16,0))什么意思
=AND(VLOOKUP(G68,wip!$C:$V,18,0),VLOOKUP(F68,wip!$E:$V,16,0))什么意思
=AND(VLOOKUP(G68,wip!$C:$V,18,0),VLOOKUP(F68,wip!$E:$V,16,0))什么意思
是函数公式
VLOOKUP意思是在WIP这个工作表的C列到V列里查找G68相对应的第18列的值,同样后面个VLOOKUP也就不难理解了.
AND的意思就是两个VLOOKUP查找成立为TRUE,否则为FLSE