#1
|
|||
|
|||
If condition related query...
How can I get the result as in the attached image using if condition based on Column A & Column B values?
|
#2
|
|||
|
|||
You create on separate sheet a crossover table with p.e. YourCode as leftmost column and Area values as headers of other columns. Like:
Code:
YourCode ME-01 RE-01 IN-01 IN-02 9901010 SHIP_MECH 9901020 SHIP_INSP 9901030 HPS_MECH 9901090 SHIP_INST HPS_INST Into column C of your current table, you enter the formula: Code:
=INDEX(tCO, MATCH([@CODE],tCO[YourCode],0),MATCH([@AREA],tOC[#Headers],0)) |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Query related to Concatenate? | LearnerExcel | Excel | 2 | 02-18-2018 07:43 PM |
How to use if condition to for this ... | LearnerExcel | Excel | 1 | 12-19-2016 02:14 PM |
Query and Power Query not working Excel 2016 | bl10 | Excel | 0 | 07-22-2016 06:25 PM |
ms office related query | d19123 | Office | 0 | 07-02-2013 05:48 AM |
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? | mag | Excel | 0 | 10-18-2012 11:15 AM |