Hi Catalin / Mynda
In Excel, I can use
=IFERROR(INDEX('Table 1'!B:B,MATCH(A2,'Table 1'!A:A,0)),INDEX('Table 2'!B:B,MATCH(A2,'Table 2'!A:A,0)))
How about in Power Query,
See my attached excel, source query done half way, what is the best method to put album and details in two columns
Hi Chris,
Append Table2 to Table 1, this will create a single table with all data. Use this single full table to merge it with the single column table.
Hi Catalin,
Yes, however in real life, the Table 1 and Table 2 and subsequent tables are with different headers, by appending them together will be very messy, so is there an equivalent M Code for
=IFERROR(INDEX('Table 1'!B:B,MATCH(A2,'Table 1'!A:A,0)),INDEX('Table 2'!B:B,MATCH(A2,'Table 2'!A:A,0)))
or nested loop for looking up values from one table to another.... if UI cannot do it
I really cannot see the problem you see. You just have to rename the columns that have the same data before append, the append will work.
Provide samples closer to reality, this will help you get a more useful answer.
