To get a position in academia, I'd say a qualified "yes". To get a position in industry, I'd say probably not.
My advice would be to get in the best program you can get into where there's at least two people who are doing something you're interested in. Also, keep in mind that an overall rating doesn't mean much because chemistry is a very broad discipline and no university is the best at everything. For instance, MIT or Harvard may be the best rated programs in the country but if I wanted to go somewhere for polymer science, I'd probably strongly consider the University of Akron, which almost certainly doesn't show up on any "Top 10 Chemistry Programs" list. It all depends on what you really want to do, and going to a school just because it earned a high ranking in US News and World Report doesn't make a whole lot of sense if nothing being done there interests you. One other final thing to consider: my perception is that the higher ranked the program, the more fundamental it is in the type of research that is being done there. Industry typically involves very applied science. So you may actually find that the higher rated programs actually prepare you worse for a job in Industry than some programs that are more geared toward applied chemistry. You'll find the latter at the big state schools, that offer focuses in polymer science, food science, analytical chemistry, agricultural science, and so forth - disciplines that can be hard to find at the so-called elite universities. I don't think that's a hard and fast rule, but it's something to consider.
Btw, I'm not out to knock the top tier universities. There's a reason they are rated well. Your decision just needs to be contextualized for your personal plans. In other words, rating is just a number and just because a school is regarded as "The Best" doesn't mean it's the best choice for you.