=if(and(a1>1,a1<100),Sheet1!a2,"")这样就可以了！
在sheet2里面的A2里输入以下公式=IF((A1>(1*LEFT(Sheet1!A1,1))),IF((A1<(1*RIGHT(Sheet1!A1,3))),Sheet1!A2,""),"")谢谢采纳！
在SHEET1中的A2单元格输入=Sheet2!A2
