Forum Discussion
If function
amenity price oriental pastry 18 cake 20 fruit 13 Cheese 25 how to calculate every time I put any item to calculate the price
I'd convert your price list to a table. You can use this in a VLOOKUP or XLOOKUP formula:
The formula in the price column of the table on the left is
=XLOOKUP([@amenity],Table1[amenity],Table1[price],0)
Demo attached.