cell A contains a short statement (e.g: 'supply of computers', 'supply of furniture', 'construction of water taps' and 'construction of water suppl'y
cell B contains list of identifiers (e.g.'Teaching learning materials', 'Water and Sanitation', etc)
I need if cell A contains "computers" or "furniture", automatically fill cell C with "Teaching learning materials", and if Cell A contains 'Construction of water supply' fill cell C with 'Water and Sanitation'
Find word within cell & put "value from a list" in adjacent