1
Formula Looks to be correct but retursn #NAME error.
Post Flair (click to view more posts with a particular flair)
Author Summary
projectreap is
in
NAME
Post Body
I am working on a large list of keywords that I am trying to sort into groups within excel and my beginner status means I am not smart enough to solve this probkem.
I would use the formula below constantly if I could just get it to work and I cannot figure out why it doesn't. I have seen examples in the post I got it from that show it working but I cannot replicate it in Excel 2016.
All I want to do is have the formula search for a specific word (House) out of the cell and return to me the value "House" if True and if not, search for the word Home and return that if it's present instead. If neither are present then return other.. Formula from this post originally.
Formula
=IF(ISNUMBER(SEARCH(“House”,A2)),”House”, IF(ISNUMBER(SEARCH(“Home”,A2)),”Home”,”Other”))
Author
Account Strength
100%
Account Age
8 years
Verified Email
Yes
Verified Flair
No
Total Karma
121,699
Link Karma
8,084
Comment Karma
111,765
Profile updated: 4 days ago
Posts updated: 8 months ago
Subreddit
Post Details
Location
We try to extract some basic information from the post title. This is not
always successful or accurate, please use your best judgement and compare
these values to the post title and body for confirmation.
- Posted
- 8 years ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/excel/comme...