Return index of another table based on multiple matching criteria with Power Query

[Anonymous]

I have two tables like below:

Table 1

Index	Make	Model	Type
0	Toyota	Corolla	Car
1	Toyota	Yaris	Car
2	Suzuki	Katana	Motorcycle

Table 2

Make	Model	Type
Toyota	Corolla	Car
Suzuki	Katana	Motorcyle

I want to add a custom column using Power Query to Table 2 that looks up the "Make", "Model" and "Type" values and returns the corresponding "Index" from Table 1. Example output is below.

Make	Model	Type	Custom
Toyota	Corolla	Car	0
Suzuki	Katana	Motorcyle	2

I've tried doing this using multiple combinations of List.PositionOf and List.MatchAll, but haven't been successful so far and would appreciate some help.

[ryan_mayu · Accepted solution]

@Anonymous 

you can use merge. press ctrl and choose matching columns. you can see 1,2,3 in the column name

[Anonymous]

This is huge. Thanks heaps @ryan_mayu 

[ryan_mayu]

you are welcome