파워쿼리로 만들어 봅니다.

=LET(r,IFNA(IFERROR(TRIM(TEXTSPLIT(C3,"*",","))*1,VLOOKUP(TRIM(TEXTSPLIT(C3,"*",",")),표1,2,0)),1),SUM(BYROW(r,PRODUCT)))

=LET(
txt,SUBSTITUTE(C11,CHAR(10),","),
a,FILTER(TRIM(TEXTSPLIT(txt,,",")),TRIM(TEXTSPLIT(txt,,","))<>""),
item,TRIM(TEXTBEFORE(a&"*","*")),
qty,IFERROR(--TEXTAFTER(a,"*"),1),
price,XLOOKUP(item,표1[품목],표1[가격],0),
amt,qty*price,
det,BYROW(HSTACK(item,qty,price,amt),
LAMBDA(r,
INDEX(r,1)&" "&INDEX(r,2)&" x "&TEXT(INDEX(r,3),"#,##0")&" = "&TEXT(INDEX(r,4),"#,##0")
)
),
VSTACK(
"총금액 : ₩"&TEXT(SUM(amt),"#,##0"),
det
)
)

=LET(TB, 표1, TXT, C3,
DD, TEXTSPLIT(TXT,,{","," "},1),
NM, TEXTBEFORE(DD,"*",,,1),
QT, IFERROR(TEXTAFTER(DD,"*"),1),
UP, VLOOKUP(NM, TB,2,0),
TA, QT*UP,
VSTACK("총금액 : " & TEXT(SUM(TA),"\#,##0"), NM & " " & QT & " x " & UP & " = " & TA))

​

=LET(구입,C11,
Data,TRIM(IFNA(TEXTSPLIT(구입,"*",",",TRUE),1)),
품목, INDEX(Data,,1),
개수, INDEX(Data,,2),
가격,VLOOKUP(품목,표1,2,0),
VSTACK( TEXT(SUM(개수*가격), "총금액 !: \#,##0"), 품목 &" "& 개수 &" x "& 가격 & " = "& 개수*가격))

​