Rlazer
09-19-2018, 05:18 PM
Hi I have two worksheets.
I want to compare cell B2 in worksheet 'applications' - with cells $B$2:$B$16 in worksheet 'grants' such that if a cell in worksheet 'grants' has more than three similar words to cell B2 then the agreement ID correlating to that cell in worksheet 'grants' is reflected in worksheet 'applications' next to cell B2 under the heading 'Awarded'.
please help!
I want to compare cell B2 in worksheet 'applications' - with cells $B$2:$B$16 in worksheet 'grants' such that if a cell in worksheet 'grants' has more than three similar words to cell B2 then the agreement ID correlating to that cell in worksheet 'grants' is reflected in worksheet 'applications' next to cell B2 under the heading 'Awarded'.
please help!