Find a value, display, whilst ignoring duplicates

[Tiebomb]

Hi Guys - looking for an expert to help with this one.

Having trouble in finding/showing values (E2 | F2 | G2) when there are duplicates in a range (A2:B8).

Essentially:

Cell E2 - Lookup D2 amongst Column A, display adjacent value (display B3 - 1111A)
Cell F2 - Lookup D2 amongst Column A, however ignore E3 (display B5)
Cell G2 - Lookup D2 amongst Column A, however ignore E3 & F3 (display B8)

Thank you

 

[Alex Blakenburg]

See if this will work for you.

=TRANSPOSE( UNIQUE( FILTER($B$2:$B$11, $A$2:$A$11=D2) ))

 

[Tiebomb]

champion - thank you!!

 

[Alex Blakenburg]

You're welcome. Glad I could help.