If it is always 3 digits and you can use a helper cell, just get the left
digits in another column and do the lookup that way.
For example if 10-154-BPF is in A1 then place this in B2
=LEFT(A1,LEN(A1)-3)
then do the lookup off of that. There are other ways if this is not possible
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Juan" wrote:

Hi,
hope I can explain what I'm trying to do. Let say, in one sheet column a I
have
Part 10-154
Then in another sheet column A I have part
10-154PBF.
I know when I do a Vlookup it doesn't find it because they don't match.
So is there a way to bring it basically if part is almost same
the difference is the last 3 digits.

So what I'm thinking is it would look like
Column A Column B
10-154 10-154PBF
Or maybe there is a if function i can use?
Would appreciate any help
Thanks,
JH