如题所述
如果查找单元格在A2单元格,另一个表Sheet2的数据区域为D2:G15,那么输入以下公式
=IFERROR(ADDRESS(SUMPRODUCT((Sheet2!$D$2:$G$15=A2)*ROW($D$2:$G$15)),SUMPRODUCT((Sheet2$D$2:$G$15=A2)*COLUMN($D$2:$G$15)),4,4),"不存在")
详见附图同表举例