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

multiful 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

1 REPLY 1
Community Support Team
Community Support Team

Re: multiful condition vlookup

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.