Any help would be greatly appreciated.
I want to type a sentence (multiple words) into cell A1 (tab 1) and if any of the words match a list of words in A:B (tab 2 - Ref. Cert. Tab) returns the value from column B (tab 2 - Ref. Cert. Tab)
I have managed to achieve this in part with partial matching but this only works if there is one word in cell A1 but i want to be able to type a sentence into cell A1
=VLOOKUP("*"&A1&"*",'Ref. Cert. Tab'!A:B,2,FALSE)
I want to type a sentence (multiple words) into cell A1 (tab 1) and if any of the words match a list of words in A:B (tab 2 - Ref. Cert. Tab) returns the value from column B (tab 2 - Ref. Cert. Tab)
I have managed to achieve this in part with partial matching but this only works if there is one word in cell A1 but i want to be able to type a sentence into cell A1
=VLOOKUP("*"&A1&"*",'Ref. Cert. Tab'!A:B,2,FALSE)