• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by elloelloHllo

  1. E

    Sumproduct for two way lookup with text values

    Hello, I have the following data table which I'm trying to look up to: Code COY1 COY2 1 Keep Keep 2 Reject Keep 3 Reject Reject 4 Keep Reject For example, I want to find the result if Code =1 and Company = Coy2 I have used the following formula but it only works if I change the data in...
Back
Top