VLOOKUP EVOLVED.....HELP
 

(Spreadsheet A) I have a cell that has a sentance in it, one of the words in
that sentence is in a seprate worksheet (spreadsheet B).

Next to the sentence in another row i have 'X' (spreadsheet A)

I need to have 'X' be returned in spreedsheet B accordingly