If Cell A1 equals "X" then call out the Cell A2, if Cell A1 equals "Y", then call out the Cell A3

Options

Hi,

Just wondering if there is any formula i can use


If Cell A1 equals "X" in the Sheet B, then call out the Cell A2 in the Shhet B, if Cell A1 equals "Y" in the Sheet B, then call out the Cell A3 in the sheet B

Sheet B


Column A1 = X

Column A2 = $45

Column A3 = $30

Result with the formula = $45


If I change the column A1 to be "Y"

Column A1 = Y

Column A2 = $45

Column A3 = $30

Result with the formula = $30

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!