Vlookup partial text

[tonyjyoo]

Hello,

I have 2 tabs in an excel workbook.

On both tabs, I have different descriptions. For example, on Tab 1, I have descriptions such as "2016.01.27 API Security Practices", but on Tab 2, it can be labeled as "Webinar: API Security Practices 1/27/16". They are followed by several columns with matching data.

Is there a formula I can use that searches for matching parts of the cells in Tab 1 (in this case, "API Security Practices"), finds them in Tab 2, then spits out the corresponding columns?

I know I can't use V-lookup because it requires exact matches.

Any advice would be appreciated.

Thank you,
Tony

 

[Aladin Akyurek]

Maybe...

=LOOKUP(9.99999999999999E+307,SEARCH("API Security Practices",Sheet2!$A$2:$A$100),Sheet2!$A$2:$A$100)

 

[tonyjyoo]

Maybe...

=LOOKUP(9.99999999999999E+307,SEARCH("API Security Practices",Sheet2!$A$2:$A$100),Sheet2!$A$2:$A$100)

This wouldn't work because the API Security Practices is just one specific example.

Essentially I want to perform a fuzzy lookup without installing the addin, if it's possible.