Trim Vlookup results

Hello,

How can I trim the result of my Vlookup?

=SUBSTITUTE(VLOOKUP($B13,'ESR - Dowload'!$A:$W,20,FALSE),"828"," ")

I have this formula, to change 8281B7005 into 1B7005. That works fine.

How can I trim the "1B" and "005" off the result? I need to set the formula so that it removed the first s characters and the last 3 characters so I'm left with 7.

I've looked at TRIM and Upper/Lower but I cant make it work.

Thanks

Is the result of the vlookup ALWAYS a 9 digit string?
And you basically want the 6th character ?

You could do
=MID(VLOOKUP(...),6,1)

Originally Posted by Jonmo1

Is the result of the vlookup ALWAYS a 9 digit string?
And you basically want the 6th character ?

You could do
=MID(VLOOKUP(...),6,1)

Tried this but get an error message:

=MID(VLOOKUP($B15,'ESR - Dowload'!$A:$W,10,FALSE), PayDaniel, 3,FALSE), 6,1)

The lookup works by itself brings in 8281B7005


I only want character 6 ie, "7"

You've somehow combined 2 vlookups...??

Originally Posted by Stressed_Daniel

=MID(VLOOKUP($B15,'ESR - Dowload'!$A:$W,10,FALSE), PayDaniel, 3,FALSE), 6,1)

Since your original vlookup is just this
VLOOKUP($B13,'ESR - Dowload'!$A:$W,20,FALSE)
Then it should be
=MID(VLOOKUP($B13,'ESR - Dowload'!$A:$W,20,FALSE),6,1)