Excel中如何通过单元格值定位其在另一表格(假设为表1)中的范围,并引用...答:表2中B3单元格输入公式=IFERROR(LOOKUP(1,0/((LOOKUP(9^9,--RIGHT(A3,ROW($1:$9)))>=LEFT(SUBSTITUTE(表1!B$3:B$100,SUBSTITUTE(A3,LOOKUP(9^9,--RIGHT(A3,ROW($1:$9))), ), ),FIND("-",SUBSTITUTE(表1!B$3:B$100,SUBSTITUTE(A3,LOOKUP(9^9,--RIGHT(A3,ROW($1:$9))...