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!