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

Report
-
Posts
1918
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 4, 2021
-
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

Posts
1918
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 4, 2021
143
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
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!
Posts
1918
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 4, 2021
143
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!