IF VLOOKUP + partial text match...wildcards or index match?!

[Alewis2423]

Hi everybody-I'm stuck and need some help here. I'm trying to write a function that looks for an ID # on another page (EXPORT) and pulls a designated value (XXL) IF it finds a partial text match (XXL) within text that will read "Custom XXL - Protein Powders" + a few other variations that all start with "Custom XXL". If that column does NOT contain XXL I don't want the function to return anything.

This if what I've tried unsuccessfully =IF(VLOOKUP($A1,EXPORT!$B2:$I$5000,8,false)="*XXL*","XXL","")

Any ideas? I'd really appreciate the help! Thanks!

 

[Stan_C]

Can you post an example of your data?

 

[Alewis2423]

I would, but unfortunately it has customer information Anything else I could provide to make it more clear what I'm looking for?

 

[Stan_C]

Just use an example of John Doe with the data and the give the expected outcome...