lookup用vlookup替代达到不用升序排列查询值=LOOKUP($B3,INDIRECT($A$1&"!$B$2:$B$59"),INDIRECT($A$2&"!"&CHAR(74+COLUMN())&"$2:"&CHAR(75+COLUMN())&"$59"))-LOOKUP($B3,INDIRECT($B$1&"!$B$2:$B$59"),INDIRECT($B$2&"!"&CHAR(74+COLUMN())&"$2:"&CHAR
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/05 17:11:50
![lookup用vlookup替代达到不用升序排列查询值=LOOKUP($B3,INDIRECT($A$1&](/uploads/image/z/9291351-39-1.jpg?t=lookup%E7%94%A8vlookup%E6%9B%BF%E4%BB%A3%E8%BE%BE%E5%88%B0%E4%B8%8D%E7%94%A8%E5%8D%87%E5%BA%8F%E6%8E%92%E5%88%97%E6%9F%A5%E8%AF%A2%E5%80%BC%3DLOOKUP%28%24B3%2CINDIRECT%28%24A%241%26%22%21%24B%242%3A%24B%2459%22%29%2CINDIRECT%28%24A%242%26%22%21%22%26CHAR%2874%2BCOLUMN%28%29%29%26%22%242%3A%22%26CHAR%2875%2BCOLUMN%28%29%29%26%22%2459%22%29%29-LOOKUP%28%24B3%2CINDIRECT%28%24B%241%26%22%21%24B%242%3A%24B%2459%22%29%2CINDIRECT%28%24B%242%26%22%21%22%26CHAR%2874%2BCOLUMN%28%29%29%26%22%242%3A%22%26CHAR)
lookup用vlookup替代达到不用升序排列查询值=LOOKUP($B3,INDIRECT($A$1&"!$B$2:$B$59"),INDIRECT($A$2&"!"&CHAR(74+COLUMN())&"$2:"&CHAR(75+COLUMN())&"$59"))-LOOKUP($B3,INDIRECT($B$1&"!$B$2:$B$59"),INDIRECT($B$2&"!"&CHAR(74+COLUMN())&"$2:"&CHAR
lookup用vlookup替代达到不用升序排列查询值
=LOOKUP($B3,INDIRECT($A$1&"!$B$2:$B$59"),INDIRECT($A$2&"!"&CHAR(74+COLUMN())&"$2:"&CHAR(75+COLUMN())&"$59"))-LOOKUP($B3,INDIRECT($B$1&"!$B$2:$B$59"),INDIRECT($B$2&"!"&CHAR(74+COLUMN())&"$2:"&CHAR(75+COLUMN())&"$59"))
1.用此公式达到要求了,请问可以用vlookup怎么写,达到不用查询中升序排列,且能精确查找?
2.此公式可以简化么?
lookup用vlookup替代达到不用升序排列查询值=LOOKUP($B3,INDIRECT($A$1&"!$B$2:$B$59"),INDIRECT($A$2&"!"&CHAR(74+COLUMN())&"$2:"&CHAR(75+COLUMN())&"$59"))-LOOKUP($B3,INDIRECT($B$1&"!$B$2:$B$59"),INDIRECT($B$2&"!"&CHAR(74+COLUMN())&"$2:"&CHAR
B3=vlookup($B3,indirect($A$1 & "B2:W59",COLUMN()+9,0)-vlookup($B3,indirect($B$1 & "B2:W59",COLUMN()+9,0)