依菜名所需食材 取庫存數食材名稱 (13779)

(2007版) C2=IF(VLOOKUP(B2,F:G,2,)-COUNTIF(B$2:B2,B2)>=0,","&B2,"")&IFERROR(VLOOKUP(A2,A3:C12,3,),"")

G10=MID(VLOOKUP(F10,A:C,3,),2,99)