vlookup only the right most 4 digits of the 6 digits sequential numbers

i have the following working great, but would like to see it refine a little, as the data vlookup is 6 digits, but i only needs the last 4 digits is enough for me to work, my question is how do i go about adding that to the following function i have implemented and working fine.


=IF(ISERROR(VLOOKUP(B4,'\\tcmfs01\home$\peter\[tracker data 4-25-14-a.xlsx]ControlSheet'!$B$2:$F$301,4,FALSE)),"",VLOOKUP(B4,'\\tcmfs01\home$\peter\[tracker data 4-25-14-a.xlsx]ControlSheet'!$B$2:$F$301,4,FALSE)

Thanks in advance

Thank you, but no cigar, we are on the right line I think, just keep getting errors...I had the "RIGHT" after the vlookup, and that didnt work either.

thanks again, but still not working

is there some precedent in function, that is preventing what i am trying to do here, because of vlookup, then testing it for validity, that might limited the "right" function to perform, is this possible?

what i am trying to say, is due to the complexity of the function, perhaps there is no room for "RIGHT" function to work properly????

test - 6 to 4 main.xlsx

The attached file is an example of what I trying to do, instead of inputting the 6 digits to import the data from the rest of the correspondent row, I want to be able to input the last 4 digits to do the same.

is it possible?

Thanks buddy, i see you have created a extra column from the source to create the 4 digits identifier, but that's what i am trying to avoid, as this is only an example, my real challenge has a lot more row than that. what i am trying to do is looking up a 6 digits identifier but using last 4 digits only to match.

Thanks again, you are probably right about this, as the situation comes up, seems always interesting to stretch the limit of the universe.