If condition related query...

LearnerExcel · #1 03-11-2018, 10:43 PM

How can I get the result as in the attached image using if condition based on Column A & Column B values?

ArviLaanemets · #2 03-12-2018, 01:37 AM

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

And I advice to defime this as a Table, p.e. tCO. And define the current table too as a Table, p.e. tCurrent.

Into column C of your current table, you enter the formula:

Code:

=INDEX(tCO, MATCH([@CODE],tCO[YourCode],0),MATCH([@AREA],tOC[#Headers],0))

Had to rename column CODE of crossover table to YourCode, as this name messed up the code tag of forum!

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