Choosing a formula, based on a list of x, y, or z

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

Post Flair (click to view more posts with a particular flair)

Waiting on OP

Post Body

Hey Guys, Thank you for the help.

=IF(K5="x",(M17=Q4),IF(K5="y",(M17=Q6),IF(K5="z",(M17=Q8),"0")))

This is the formula i have created, but have had no success with to this point. I want to use a drop down menu to be able to select the x, y, or z. I need this to trigger the selection values from other cells. I have 3 formulas in Q4, Q6, and Q8 with values (live formulas) so you would see a value of example 366, 250, and 97 in each of those cells.

m17 is the cell i want the answer, as selected from the x(q4), y(q6), or z(q8) to appear. With the above formula, i always have a zero, even though the q cells have actual values.

Thank you for any help.

Author

Account Strength

90%

Account Age

8 years

Verified Email

Yes

Verified Flair

Total Karma

677

Link Karma

177

Comment Karma

500

Profile updated: 1 week ago

Posts updated: 1 month ago

wardedout

Subreddit

r/excel

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 7 years ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/excel/comme...