Vlookup and Substitute - Combine

Hello,

I'm trying to convert the results of a vlookup from 828xxxxx, 828zzzzz etc to just xxxxx, zzzzz etc. So, I just want to take the 828 out. I have tried combining the substitute function with the vlookup but I can't get it to work.

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

The above lookup brings in the information e.g 828xxxx

=SUBSTITUTE(N13, 828, " ")

If I copy the values into another column and then use the above formula I will get an output e.g xxxx

How can I combine the above formula into one? I have tried numerous ways but just get error messages.

Any idea?

Not sure without the data but try,

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

Thanks, works great!!!!!!