Hello,

I'm looking for a formula that help me return non-repetitive value as it has same lookup value. It's a bit hard for me to explain but if you can see my attached. I will make sense what I'm looking for.

sample test.xlsx