



August 21, 2019

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


August 21, 2019

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
1 Guest(s)
