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

Find more posts tagged with

Accepted answers

All comments

Stefan

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

Paul Newcome

@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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.