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+CO

　　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.此公式可以简化么?