Why returning Zero value [closed]
Please see attachment and info on document
I have spend few hours with different variations and not able to fix, not sure why its returning a zero value. Just because the 1st column is zero or maybe thats not the reason.
thank you in advance for any help provided.
in the document TEAM 1 and T should return a value of 12 from Row 11, and the Zero value in Column M should have a value from Column B. For some reason Index - Match is only picking up value from column B if its the first name for each row If their is no value in the first name of both names then it will not return a value , but it should find the value in next row since match finds that value but does not display it correctly How is this fixed