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.
Denver, officially the City and County of Denver, is the capital and most populous municipality of the U.S. state of Colorado. Denver is in the South Platte River Valley on the western edge of the High Plains just east of the Front Range of the Rocky Mountains. The Denver downtown district is immediately east of the confluence of Cherry Creek with the South Platte River, approximately 12 mi east of the foothills of the Rocky Mountains. Denver is nicknamed the Mile High City because its official elevation is exactly one mile (5280 feet or 1609.3 meters) above sea level, making it the highest major city in the United States. The 105th meridian west of Greenwich, the longitudinal reference for the Mountain Time Zone, passes directly through Denver Union Station.