multiful condition vlookup

[colourfullife]

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>

[v-juanli-msft]

Hi @colourfullife 

Since i don't know your data from Table1, I can't make a test to achieve it.

Please re-upload the picture if my assumption below is not correct.

If table1 and table2 all have "module and group" columns,

You could merge columns for "module and group", then merge two tables based on the merged column in both tables.

Open Home-Edit Queries,

Merge columns in Power BI

Merge queries In Power BI

Best Regards

Maggie

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