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
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
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)