A | B | C | |
1 | REFER sheet 的資料格 , 沒有輸入資料 | data V | formula (顯示data V) |
2 | REFER sheet , 沒有資料 | data V | formula (顯示data V) |
3 | REFER sheet 的資料格 , 輸入文字 | data V | formula (不顯示data V) |
| ** 本身有formula** | |||
| 想要的result如下: | |||
A | B | C | |
1 | 25 | 25 | |
2 | 10 | 10 | |
3 | WOW | 5 |
|
I5000,MATCH(1,($E$3=Remarks!$B3B5000)*($B12=Remarks!$A3A5000),0),9))=TRUE," ",INDEX(Remarks!$A3I5000,MATCH(1,($E$3=Remarks!$B3B5000)*($B12=Remarks!$A3A5000),0),9))
發表於 
返回列表
