Hello All,
I have an issue where a column for a given set of data can change. I need to count the blank rows in a range, if the cell in another range matches the correct number.
The formula evaluation is showing the indirect match vlookup combo is returning thr correct ranges but the count is returning 0 for everything.
The formula I currently have is =countifs(indirect(vlookup(match("Shipping Label Printed",'Packing Record'!$1:$1,0),Master!$V:$W,2,false)),"Not Printed",indirect(vlookup(match("Ship-to CD",'Packing Record'!$1:$1,0),Master!$V:$W,2,false)),[@[Shop No]])
V column is number 1 to 32, with w column having a:a, b:b, c:c to return the correct range from the match.
I have also tried segregating the vlookup response in the indirect woth ""& &"", which still returns the correct range, but with the same result of 0.
If anybody can help me fix this it would be much appreciated
I have an issue where a column for a given set of data can change. I need to count the blank rows in a range, if the cell in another range matches the correct number.
The formula evaluation is showing the indirect match vlookup combo is returning thr correct ranges but the count is returning 0 for everything.
The formula I currently have is =countifs(indirect(vlookup(match("Shipping Label Printed",'Packing Record'!$1:$1,0),Master!$V:$W,2,false)),"Not Printed",indirect(vlookup(match("Ship-to CD",'Packing Record'!$1:$1,0),Master!$V:$W,2,false)),[@[Shop No]])
V column is number 1 to 32, with w column having a:a, b:b, c:c to return the correct range from the match.
I have also tried segregating the vlookup response in the indirect woth ""& &"", which still returns the correct range, but with the same result of 0.
If anybody can help me fix this it would be much appreciated
