=IF(ISERROR(FIND("仓",A5)),0,CONCAT(INDIRECT(ADDRESS(ROW()-1,1)),INDIRECT(ADDRESS(ROW(),1))))
使用address获取单元格地址;再使用indirect获取单元格内容
=IF(ISERROR(FIND("仓",A5)),0,CONCAT(INDIRECT(ADDRESS(ROW()-1,1)),INDIRECT(ADDRESS(ROW(),1))))
使用address获取单元格地址;再使用indirect获取单元格内容