Combine Vlookup and Right Function

[joe675]

Hello I am trying to combine the Vlookup and the Right function in one cell. Basically I am using the Vlookup to get a number from another sheet but I only need the last five digits of a ten digit number.

I can do the Vlookup ex. in cell B5 I enter =VLOOKUP(E5,E5:F17,2,2) then use the right function =RIGHT(B5,5) to get what I need, but am just trying to save a step.


Thank you

 

[akanchu]

=right(VLOOKUP(E5,E5:F17,2,2),5)

should work. Are you getting any errors.
if required you can make the format it as text.

 

[joe675]

Awesome, works great thank you