How to use xlookup, vlookp returning 2nd value

[chingg1011]

Hi expert,

How to use xlookup or vlookup to locate 2nd value "pass-1" ?

 

[SunnyAlv]

maybe u can try like this, i think its not bout 2nd place, but how to avoid the #N/A

=INDEX(B2:B3,
   XMATCH(1,(NOT(ISERROR(B2:B3)))*(A2:A3=E2),0))

but if u want to show 2nd place/last cell u can use Xlookup with Search Mode, Like:

=XLOOKUP(E2,A2:A3,B2:B3,,,-1)

but