Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula: Look Up for two value
This one is pretty easy in Excel but I have no idea how to do that in SmartSheet.
I have 3 columns in SS: Fruit, Brand and Price
[Fruit]1 is Apple , [Brand]1 is ABC Ltd. [Price]1 is 100
[Fruit]2 is Apple , [Brand]1 is XYZ Ltd. [Price]1 is 50
[Fruit]3 is Pear, [Brand]1 is ABC Ltd. [Price]1 is 100
I want to have formula to find price of XYZ Ltd Apple, the answer should be 50.
How can I do it in SS?