Partial Match V-Lookup with two different sheets

I'm running into an issue creating a Partial Match V-Lookup using two different sheets. While I have managed to get the V-Lookup done for an exact match, I'm struggling to get the same accomplished for a Partial Match. Here is what I'm trying to accomplish:

Based on the SKU (Sheet 1 Column A) I need to know what Gender the SKU refers too (Sheet 1 Column B is the formula field).

So if parts of the SKU in Sheet 1 Column A match the SKU in Sheet 2 Column A then answer with the corresponding Gender (Sheet 2 Column B).

I hope that makes sense and I hope that someone can give me some help with the formula.

Thanks,

Sweden12

How about in B2 on Sheet1 copied down >> =VLOOKUP(MID(A2,4,3)+0,Sheet2!$A$2:$B$5,2,0)

Not sure you updated your example as it looks the same.

How about >> =VLOOKUP(LOOKUP(99^99,--LEFT(MID(A2,MIN(FIND({1,2,3,4,5,6,7,8,9,0},$A2&"1023456789")),999),ROW(INDIRECT("1:999")))),Sheet2!$A$2:$B$5,2,0)

You are very welcome and thanks for the feedback. Happy it helped.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.