Is there a smart way to: XLOOKUP. If value A is duplicate show next value

[MRDBS]

Hey

Really sorry if my question has an obvious answer, I blame it on it being really early and my logic engine not yet being fired up.

I am trying to look up next value in an array, if the lookup value is a duplicate to the one above.

I am currently using XLOOKUP to find values in another sheet.
=XLOOKUP(A;B:B;C:C;0) (Simplified)

Now I would like to add an if function,
=XLOOKUP(A2;B:B;If(A2;A1;(C:C)+1;C:C);0)
I also tried:
=IF(A2;A1;(A;B:B;(C:C)+1;(A;B:B;C:C;0)))

I am not sure (C:C)+1 works, do you have an alternative suggestion.

Thank you!

 

[Fluff]

Glad you sorted it & thanks for the feedback.