• 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


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

Help with lookup

Hi, I have attached file. I'm trying to look up values from "Sourcr tab" referencing to columns A and B ad the result to be produced in "result tab"

What makes it complicated is there are lot of duplication in column A

Kindly assist with formula



you also can concatenate columns A and B in a separate column in both sheets and do the look up.