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