First of all there are two ways to use Vlookup, Either with exact match or range match. Range match is best used with the example of grading eg A=91-100%, B=81 -90% etc. If used properly there is not much issue. The major issue arises in exact Match. Here the spellings have to be exactly correct.
The Colorado Rockies are an American professional baseball team based in Denver, Colorado. The Rockies compete in Major League Baseball (MLB) as a member club of the National League (NL) West division. The team's home venue is Coors Field, located in the LoDo (Lower Downtown) area of Denver. The Rockies have won one National League championship (2007). The team mounted a rally in the last month of the 2007 regular season, winning 21 of their final 22 games, and reached the 2007 World Series.
The Rockies. The Rockies are a well-named group of jagged, snow-capped peaks which run through the western part of North America. This chain of mountains extends over 3,000 miles and is almost 1,000 miles wide in some places. They begin in Northern New Mexico and extend as far as northern Alaska. From New Mexico, the mountain range stretches through Colorado, Utah, Wyoming, Idaho, and Montana. At the International Border, the part of the range known as the Canadian Rockies passes through the provinces of Alberta and British Columbia, and the Northwest Territories and Yukon Territory of Canada. The Rocky Mountain range is part of the Cordilleran chain which reaches from Cape Horn to the Arctic Circle.