=INDIRECT(ADDRESS(ROW(A3),MATCH($CA$30,表格3!$3:$3,),,,表格1))&或=IF(INDIRECT(ADDRESS(ROW(A3),MATCH($CA$30,表格3!$3:$3,),,,表格1))=0,,INDIRECT(ADDRESS(ROW(A3),MATCH($CA$30,表格3!$3:$3,),,,表格1)))如果返回值为数值,最后用第二条公式
Copyright © 2025 IZhiDa.com All Rights Reserved.
知答 版权所有 粤ICP备2023042255号