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

Closed
dochula - May 26, 2016 at 02:33 AM
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 - May 26, 2016 at 08:57 AM
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!

2 replies

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
May 26, 2016 at 08:03 AM
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
0
Hi,
Thank you for your prompt help. I have attached the excel at this link. http://speedy.sh/QqfQp/formula-enquiry-HELP-please.xlsx.

Please see you can help.

Thank you HEAPS!
0
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
May 26, 2016 at 08:57 AM
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.
0