關於 Excel VLOOKUP 問題

2011-01-11 5:39 am
請問各位點解用=VLOOKUP寫 formula 時, 若選擇空白會出現 #N/A, 條 formula 點寫先唔會出現呢?

回答 (2)

2011-01-11 5:57 am
✔ 最佳答案
=if(isna(vlookup(......), " ", vlookup(.....))

2011-01-11 15:58:13 補充:
=if(isna(vlookup(......)), " ", vlookup(.....))

omit a bracket after first vlookup formula
2011-01-11 8:23 pm
不成功, 應該怎辦????


收錄日期: 2021-04-13 17:45:41
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20110110000051KK01279

檢視 Wayback Machine 備份