Lookup Value for 2 columns

[cristianml]

Hi,

I need to do a Lookupvalue in a new column to find data from 2 columns (Query data) to give me a result from a table I created (Mapping table: Level Type):

Query data
Type / Career Track	Level
Client & Market	11 - Analyst
Client & Market	6 - Senior Manager
Client & Market	Accenture Leadership
Operations	10 - Analyst
Operations	11 - Analyst
Operations	12 - Associate
Operations	13 - Associate
Operations	9 - Consultant
Operations	Accenture Leadership
Corporate	11 - Analyst
Corporate	12 - Associate
Corporate	8 - Consultant
Innovation	5 - Associate Director
Innovation	8 - Consultant
Subcontractor
Unassigned

mapping table
Level	Level Type
5 - Associate Director	05 - Associate Director
6 - Senior Manager	06 - Senior Manager
7 - Manager	07 - Manager
8 - Consultant	08 - Consultant
9 - Consultant	09 - Consultant
10 - Analyst	10 - Analyst
11 - Analyst	11 - Analyst
12 - Associate	12 - Associate
13 - Associate	13 - Associate
Subcontractor	Subcontractor
Unassigned	Unassigned

I tried LOOKUPVALUE combined with IF  / IFERROR / OR but I Couldn't find a Logic formula.

Thanks,

[parry2k]

@cristianml I guess you want level type in table 1 below from mapping table based on matching value of Level column, correct?

Set relatioship between both the tables on Level, in relatioship 1 side will be mapping table and many side will be your data table, and add following column in your data table

Level Type = RELATED( MappingTable[LevelType] )

[cristianml]

Hi,

What I need is to have in one column the result of these two formulas :

LOOKUPVALUE('Map resource Level Type'[Level Type],'Map resource Level Type'[Level],'Resource Actual'[Type / Career Track])
LOOKUPVALUE('Map resource Level Type'[Level Type],'Map resource Level Type'[Level],'Resource Actual'[Level])

Without making any relationship. Is possible ?

Thanks.

[parry2k · Accepted solution]

@cristianml you can surely use lookup if you don't want to create relations and combine the value returned by both lookup in one column.

The firest lookup will not any return based on sample data becuase there is no matching row, to combine just do following

My Lookup Value = 

LOOKUPVALUE('Map resource Level Type'[Level Type],'Map resource Level Type'[Level],'Resource Actual'[Type / Career Track]) 
&
LOOKUPVALUE('Map resource Level Type'[Level Type],'Map resource Level Type'[Level],'Resource Actual'[Level])