I've got he following formula which sumproduct multiple spreadsheets based where and item reference is found.
What I'm trying to do is use the above formula "amended" to return a text value. I can only get it to true or false and it will not declare the text
The idea is that it will only return a text value is the code above =0 value.
I've tried to upload a but for some reason will not let me.