I'm having issues with an array formula:
Assume:
Z4 = Product 1
AA3 = CC1
If these values are both found, it returns the correct value/total I need. my problem arises when the values searched for aren't in the arrays. according to the coding, it should return "". currently it is returning a value of 0.
if i change the formula to:
or
it still returns a value of 0 not the 'none' or '1' values I'd expect.
if I change the code to:
I get a completely random seeming value. i.e. not 1 and not 0 as expected.
any suggestions would be appreciated.
r/
SUPPO
Bookmarks