Help with lookup

[Ecel Dumbo]

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

 

[Nebu]

Hi:

Here you go,

Thanks

 

[Ecel Dumbo]

THank you very much Nebu

 

[Siga]

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