Prevent Duplicates in Xlookup formula?

[Glasgowsmile]

Is there a way to prevent xlookup to bring in duplicate data?

A1: Source
B2: Formula

The data is things like 1 - Segment, 2 - Field, 3 - Range and they repeat several times but I don't want to them to repeat in B2 but rather just pull 1 instance of each.

Maybe I need a filter formula in a helper column to assist?

 

[RasGhul]

Hello,

Are you able to post some sample data?

 

[jasonb75]

Perhaps it could be as simple as

=UNIQUE(XLOOKUP(...))