求助Excel公式問題!

excel

1个回答

写回答

=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)))如果返回值为数值,最后用第二条公式

举报有用(0分享收藏

Copyright © 2025 IZhiDa.com All Rights Reserved.

知答 版权所有 粤ICP备2023042255号