Which formula can $be$ inserted into cell $G5$ and copied $to$ all the cells $of$ column $Gto$ calculate

the overall price $of$ the items?

$==$XLOOKUP$(E5,$$$A$$$2$:$$A$$$18,$ $$C$$$2$:$$C$$$18,0)*XLOOKUP(E5,$$$E$$$2$:$$E$$$18,$$$F$$$2$:$$F$$$18,0)$

$=F5*XLOOKUP(E5,A$:$A,C$:$C,0)$

$=$ FIND$(E5,$$$A$$$2$:$$A$$$18,0)$

$=F5*XLOOKUP(E5,A2$:$A18,C2$:$C18,0)$