I have a string of text in a column that I would like to compare with text from another worksheet, and return a value from an adjacent cell in the second worksheet.
So for instance:
-In Sheet1, cell A1 contains text "Bob built a house in Georgia"
-I would like to compare A1 to a column from a second worksheet and find a cell that matches text with the string found Sheet1A1, ie Sheet2A4 contains "Georgia,"
-If Sheet2A1 matches partial text found in Sheet1A1, I would like to return the value found in a cell adjacent to Sheet2A1 ie Sheet2B4 or "1988".
Sorry for probably not writing this as clear as it can be. Any help would be appreciated!