How to get Unique Value from another Table

[ritendersingh2]

Hello There,

Need little help here with something

I am attaching excel sheet with data and my requirment

[#2 · Accepted solution]

@ritendersingh2 

See the attached version. I added a helper column for the BGV result.

Pedant alert: discrepency and discrepecy should be discrepancy.

[#3]

Thanks Hans