So you are matching Cappuccino on Sheet1 with 2.25 and 2.95 on Sheet2 based purely on position on the sheet?
You could get Index and match to do it but column C can only be Either a typed cell or a formula
On the attached i have added column C as a formula so if you add in a duplicate it will find the first one in the previous cells, but if its not found it will say #ref and you will need to over type.
You could do simular with an extra column that might look better
|