问题已解决
=IF(F4="","",VLOOKUP(F4,庫存表!C:C,1,0)) =IF(F3="","",IF(VLOOKUP(F3,庫存表!C:C,1,0)=O3,"ok","型號(hào)不對(duì)")) =IF(P8="OK",VLOOKUP(F8,庫存表!C:F,3,0),"") 老師上述3個(gè)函數(shù)公式在表達(dá)什么,請(qǐng)老師翻譯一下,謝謝!
![](https://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/010/88/22/51_avatar_middle.jpg?t=2025021314)
1、如果f4為空,返回空,否則在庫存表c列查找f4的值
2019 08/19 08:52
![](https://pic1.acc5.cn/010/88/22/51_avatar_middle.jpg?t=2025021314)
風(fēng)老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 08/19 08:57
2、如果f3為空,返回空,否則判斷在庫存表c列查找f3的值是否等于o3,若等于返回ok,不等返回型號(hào)不對(duì)
![](https://pic1.acc5.cn/010/88/22/51_avatar_middle.jpg?t=2025021314)
風(fēng)老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 08/19 09:00
3、如果p8為ok,在庫存表c列查找f8并返回對(duì)應(yīng)e列的值,否則返回空
![](https://pic1.acc5.cn/010/88/22/51_avatar_middle.jpg?t=2025021314)
風(fēng)老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 08/19 09:03
3、如果p8為ok,在庫存表c列查找f8并返回對(duì)應(yīng)e列的值,否則返回空
![](/wenda/img/newWd/sysp_btn_eye.png)