The formula is Year End Status = CALCULATE ( MAX ('All Case Statuses' [StatusID]), Return value from another column 07-19-2017 02:46 PM I'm using lastnonblank to find a value in a table (all case statuses), but want to bring back the value in a different column in that same row. We can now get the value of Apple from both types like this. The article will explain five formula-based methods to lookup a value in one column and return the value of another column in Excel. VLOOKUP: Vertical lookup. DAX to retrieve value from another column based on a condition. ADDRESS means I can build the cell reference. range_lookup is whether the result will be an exact or partial match. Say, the value is DD. The IF functiontakes the logical argument on basis of which true or false will be determined. . Use the Formula Handbook template to find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas. This brings back the Case Status Description from the All Case Statuses table, but I also want to bring back another value (and upt in a differect column)based on the same search value. This is Syeda Fahima Nazreen. I have fil. Sessions throughout each day brought by Microsoft MVPs, knowledge leaders, and technical experts from across a wide variety of industries. Using VLOOKUP and IFERROR to Lookup Value in Column and Return Value of Another Column 4. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems. Lastly, we can also combine the TEXTJOIN and IF functions to lookup for a value in a column and get the result of value from another column. I would like to return the value in 'Comment' column that contains 'Name'. [CDATA[ */ ' Get value from Dictionary Total = dict ( "Apple" ) ' Get value from Collection Total = coll ( "Apple" ) So far so good. How do I get the code to match the inputted teams to "home_team" and "away_team" in the table and finally return the value 'H' which is from the column 'result' ? By clicking Accept all cookies, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy. I need help in writing a DAX for retrieving a value from another coumn based on a condition. I hope this article has helped you solve your problem. I earn a small commission if you buy any products using my affiliate links to Amazon.
The formula for the given dataset will be: The IFERROR function takes two arguments value and value_if_error.