Hei ...
I have this spreadsheet with a few hundred rows, contaning a series of tables for the net. Each with its own headers.
The problem, it seems, is that those headers are halting my look-up functions in another spreadsheet.
The formula that do not work is like this: =SUMPRODUCT((data!$D:$D=$D6)*data!M:M)
The formula that works is like this; =SUMPRODUCT((data!$D$2:$D$200=$D6)*data!M$2:M$200)
Is there a way to avoid header row in Power Query?
Bookmarks