Index Match /Vlookup issue

[DeaninGA]

So I have a column of data that has various part numbers in. (CVS8H900b2030HILE3) for instance. I need to extract the HILE3 part and match it to a Vlookup style table to return an extended description of that part. The issue is its not always HILE3 it could be some other series of letters and it might e 1 or 2 characters more or less than the HILE3... I have a Vlookup style table with the complete list on a support tabe with the answers I want it to return. Any help would be greatly appreciated.

DD

 

[Aladin Akyurek]

Let A2 house

CVS8H900b2030HILE3.

Let F2:G100 house the lookup table.​

In B2 enter (and copy down if you have other values to look up)...

=LOOKUP(9.99999999999999E+307,SEARCH($F$2:$F$100,$A2),$G$2:$G$100)

 

[DeaninGA]

Let A2 house
CVS8H900b2030HILE3.

Let F2:G100 house the lookup table.

In B2 enter (and copy down if you have other values to look up)...

=LOOKUP(9.99999999999999E+307,SEARCH($F$2:$F$100,$A2),$G$2:$G$100)

Morning,

Thank you for the Quick Response. I tried it and getting an Error Here is My formula and an explanation

=LOOKUP(9.99999999999999E+307,SEARCH(RBC!A1:A96,[Description],RBC!B2:B96))

RBC!A1:A96 if the first column of a support table that contains the snippets of data im trying to extract from the part numbers in the "Description" column of a data table( represented by the PN I originally gave you), "Description" is the name of the column I'm trying to pull the data into. RBC!B2:B96 is the result Im trying to pull into the cell where this formula resides... I know I'm doing something wrong. thank you again
DD

 

[Aladin Akyurek]

The ranges are not equally sized. Set them equal in length. Does this resolve the issue?

=LOOKUP(9.99999999999999E+307,SEARCH(RBC!A1:A96,[Description],RBC!B1:B96))

 

[DeaninGA]

@Aladin Akyurek oh good grief ... Yep it worked thank you

 

[Aladin Akyurek]

You are welcome.