Forum Discussion
Solved
Return value depending on numbers in multiple other columns
Hello, Can anyone help me optimize the following formula in Excel for Office 365: =IF(INDEX(list2!$D:$D; MATCH(1; COUNTIFS(C3; list2!$E:$E; C5; list2!$F:$F)+COUNTIFS(C3; list2!$G:$G; C5; list2!$H:$...
I've converted 'data' and 'items' to dynamic named ranges and updated 'GetData' so it will still calculate if an item is missing.
For editing named items and functions, I'd recommend using Advanced Formula Environment (Part of Excel Labs):
Your sample file looks very promising.
But is it possible to do it without the "external data source"?
I'm trying to figure out which source is used, but can't find how, being completely new to PQ.
Can you explain to me, step by step, how you created the result?
Thanks,
Matt