Hi,

Not sure how complicated the formula will get. if I have two different datasets, both contain questions that share a text similarity of approx 50%-70% and in practice they need to matched up or aligned next to each other in one sheet (currently in two sheets). Example

Sheet 1: CELL:A2 = How important is it to you to complete your studies or do the following?

Sheet 2: CELL:F100 = How important is it to you that your students complete the following?

Thus there is a level or similarity and I need to "simply" (which is a term never used in excel :P) pull in the information from Cell F100 next to i.e. Cell B2 in sheet 1.

Anyone want to accept this challenge as I'm out of ideas? There are over 300 questions and "most of them" have high level of similarity but not an EXACT MATCH.

I'm not sure as to what extent excel can apply logic to match up partial strings.


Many thanks