cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

2 condition vlookup

 

 

Good afternoon,

 

I want to take talbe 2 ROS date on table 1.

it should match module and group. any ideas?

 

thanks for any help in advance.

<Table1>

<Table2>

vlookup.PNG

2 REPLIES 2

2 condition vlookup

 

 

Good afternoon,

 

I want to take talbe 2 ROS date on table 1.

it should match module and group. any ideas?

 

thanks for any help in advance.

<Table1>

<Table2>

vlookup.PNG

Community Support Team
Community Support Team

Re: 2 condition vlookup

Hi @colourfullife ,

Your table1 snapshot seems broken, can you please fix it? 
In addition, you can also try to use below calculated column formulas based on calculate function or lookupvalue function.

Related ROS =
LOOKUPVALUE (
    Table2[ROS],
    Table2[Module Deck], Table1[Module Deck],
    Table2[Group], Table1[Group]
)

Related ROS2 =
CALCULATE (
    MAX ( Table2[ROS] ),
    FILTER (
        ALLSELECTED ( Table2 ),
        Table2[Module Deck] = EARLIER ( Table1[Module Deck] )
            && Table2[Group] = EARLIER ( Table1[Group] )
    )
)

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |