Hello,

Trying to do a makeshift MEDIANIF sort of formula. I need to refer to a database in another tab, and to refer to "Price" based on "Item"

=MEDIAN(IF(Item=B20, Price))

B20 is "Sandwich". The hard part is, I need to include all of the items that include the word Sandwich, aside from those that are just Sandwich. I'm having trouble figuring out how to format the wildcards in order to include things like "Turkey Sandwich" in the "Item" column.

help!