"Filter" or "IF" function?

Hey there,   I have created a pricing configurator for a project I am working on.    The pricelist uses the "XLOOKUP" function to search for specific prices based on the user input as it should w...