If Cell A1 equals "X" then call out the Cell A2, if Cell A1 equals "Y", then call out the Cell A3
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

Hi Jean,
without knowing what you want to achieve, here is a possible formula:
=IF([Column A1]@row = "X", [Column A2]@row, [Column A3]@row)
The formula will sit in the column with the result.
Hope this helps
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.

@lewis hamilton Yes. That is what the poster is seeking help with a solution towards. @Stefan's solution looks like it should do the trick.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 142 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!