when using VLookup, how can I search not the entire cell but parts of the
cell, that is if I want to search 4 or 5 deep. If I'm comparing, for example:

A = 123456789
B = 1234d56789

VLOOKUP(A,B,1,???) - whereas ???=FALSE to find an exact match I would want
something to search B up to 4 or 5 characters compared to A.

Does this make sense?

Thanks for the help,
-m