Return value and RIGHT

[Kerr3189]

Hello hope this is easy answer that I’m missing

I’m wanting to use a RIGHT function on a return value
The return value comes from an Xlookup that needs to be active (can’t’ copy and paste values then use RIGHT)
The value that XLOOKUP returns is 360abc I want the 360 gone automatically each time

How would I do this if possible?

 

[RoryA]

Do you always want the last 3 characters specifically, or to skip the first 3 specifically, or some other pattern?

 

[Kerr3189]

Do you always want the last 3 characters specifically, or to skip the first 3 specifically, or some other pattern?

The number at the start is always 360 and then abc changes - so I always want it to skip 360 and just show last 3 characters

 

[RoryA]

If it's always the last 3, then:

=RIGHT(XLOOKUP(...),3)

or to skip the first 3 you can use:

=MID(XLOOKUP(...),4,100)

where the 100 is just a number longer than any text you expect as a result.

 

[Kerr3189]

Thanks Rory will try that

 

[CluaseTony]

You can also include Mid inside the XLOOKUP
=XLOOKUP(lookup value,range to lookup,MID(Range where answer is,4,100))
=XLOOKUP(C11,A3:A6,MID(B3:B6,4,100))