Music, applause, music. Hello everyone and welcome to the Excel challenge. In this video, I'm going to show an easy way to find the intersection of two values in a table. For this example, I'm using the driving distance between US cities. I have 15 cities on the left and 15 cities on the top. Let's say you want to find the driving distance between Miami and Tampa. The distance between Miami and Tampa is 329 miles. If you want to see how to build this spreadsheet, please stay tuned. Okay, the first thing we want to do is prepare our database. The database I prepared for this example is a simple table of 15 US cities that we can see in these 15 rows and the same 15 cities in these 15 columns. If I want to know the distance from Chicago to Dallas, I can see the distance is 1,290 miles. The same idea applies to Denver to Miami, which is 2,772 miles. Now, the key to resolving this challenge is to understand rows and columns. What I'm going to do next is temporarily write a row number for each of the 15 cities on the left and a column number for each of the 15 cities on the top. The challenge today is to identify the distance from, let's say, Chicago to Houston. The first thing we want to know is the row number of this intersection. By the way, the intersection here is Chicago's in Row 3 and Houston is in Column 6. In order to understand the row number, we're going to use the match formula. So, I'm gonna tell Excel "match" open parenthesis. The lookup value is going to be the city that I'm driving from, comma, and my lookup array or my lookup range is going...
Award-winning PDF software
Video instructions and help with filling out and completing Who Form 2220 Columns
