Find word within cell & put "value from a list" in adjacent Closed

Question

Hello, 

If 
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'

Please Help!

Mazzaropi · Answer

dochula, Good morning. 
 
Your question is not clear enough.
Your example can´t give us a right way to advise you.

Please, explain it again and if possible save a little example of your Excel file at a free site, www.speedyshare.com and put a link to download here.

We want to help you as soon as possible.
 --
Belo Horizonte, Brasil.
Marcílio Lobão

Mazzaropi · Answer

dochula,  

Your necessity is more complex than the original explanation.
 
I believe that your solution will be found using VBA EXCEL.

I can´t see a solution using only formulas.
Unfortunately I don´t know VBA EXCEL.

I hope that others users here can help you.

Find word within cell & put "value from a list" in adjacent

2 responses

Similar discussions

Subscribe To Our Newsletter!