Find words within cell & put value in adjacent
Closed
Grouchoed
Posts
1
Registration date
Wednesday October 7, 2015
Status
Member
Last seen
October 8, 2015
-
Oct 8, 2015 at 12:26 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 8, 2015 at 10:23 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 8, 2015 at 10:23 AM
Related:
- Find words within cell & put value in adjacent
- If cell contains date then return value - Excel Forum
- Conditional formatting if cell contains text - Excel Forum
- Count if cell contains number - Excel Forum
- If cell A1 has text then cell B2 has today's Date ✓ - Excel Forum
- Excel send value to another cell - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 8, 2015 at 10:23 AM
Oct 8, 2015 at 10:23 AM
Grouchoed, Good morning.
I'm not sure if I understood well your question.
Try to use:
B2 -->
=IF(COLUMN()=IFERROR(LOOKUP(2,1/FIND({"Roofing","Painting","Contractor","Construction","Concrete","Paving","Sheet Metal","Welding","Reconstruction","Woodworks","General Contracting"},$A2),{2,3,3,3,3,3,4,4,5,5,5}),""),$A2;"")
Copy it right till F column.
Copy it down as necessary.
Use comma or semi-colon as your Excel version.
I did a Conditional Format to point you company names that don't have any category.
Take a look at my example to you:
http://speedy.sh/KrZMh/08-10-2015-ExcelForum-Company-Categorie-OK.xlsx
Is this what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
I'm not sure if I understood well your question.
Try to use:
B2 -->
=IF(COLUMN()=IFERROR(LOOKUP(2,1/FIND({"Roofing","Painting","Contractor","Construction","Concrete","Paving","Sheet Metal","Welding","Reconstruction","Woodworks","General Contracting"},$A2),{2,3,3,3,3,3,4,4,5,5,5}),""),$A2;"")
Copy it right till F column.
Copy it down as necessary.
Use comma or semi-colon as your Excel version.
I did a Conditional Format to point you company names that don't have any category.
Take a look at my example to you:
http://speedy.sh/KrZMh/08-10-2015-ExcelForum-Company-Categorie-OK.xlsx
Is this what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
