I'm trying to write a formula which checks two ranges for a specific values and when they match up put a avlue from a different range but same line onto another sheet. If it can't find one put zero instead. How?
So far i can up with {=IF(AND(Team="Andy...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.