1 00:00:00,160 --> 00:00:03,450 The first Excel feature we'll review is lookups. 2 00:00:03,450 --> 00:00:07,280 In this video I'll introduce the VLOOKUP and HLOOKUP functions and 3 00:00:07,280 --> 00:00:09,130 discuss when to use them. 4 00:00:09,130 --> 00:00:13,350 Let's look at an example spreadsheet that shows median housing rental prices for 5 00:00:13,350 --> 00:00:14,830 counties in Texas. 6 00:00:14,830 --> 00:00:21,150 In the first tab, Median Rental \$, you can see we have columns for county, state, and 7 00:00:21,150 --> 00:00:27,560 then the median price for zero, one, two, three and four bedroom rental properties. 8 00:00:27,560 --> 00:00:32,140 On the second tab, Population & Units, you'll see we have population and 9 00:00:32,140 --> 00:00:34,430 number of housing units for each county. 10 00:00:34,430 --> 00:00:39,160 Now what if we wanted to add population and housing units to the rental price tab? 11 00:00:39,160 --> 00:00:43,630 If the counties were in the same order on both tabs, we could just do a copy and 12 00:00:43,630 --> 00:00:44,410 paste. 13 00:00:44,410 --> 00:00:48,640 But doing a quick check, it's clear the counties are not in the same order, so 14 00:00:48,640 --> 00:00:50,860 we'll need to do a lookup instead. 15 00:00:50,860 --> 00:00:54,600 Even if the counties are in the same order, I'd still prefer the lookup method 16 00:00:54,600 --> 00:00:59,040 here, as you're less likely to make a mistake using the lookup function. 17 00:00:59,040 --> 00:01:03,900 In Excel the lookup functions searches for a value in one column or row and 18 00:01:03,900 --> 00:01:07,040 then returns a value in the same column or row. 19 00:01:07,040 --> 00:01:10,910 In other words, lookup is a conditional search that 20 00:01:10,910 --> 00:01:14,270 would return a value based on the conditions you set. 21 00:01:14,270 --> 00:01:19,450 There are two different types of lookups, a VLOOKUP and an HLOOKUP. 22 00:01:19,450 --> 00:01:25,490 The V in VLOOKUP stands for vertical, so it will do a search and find in a column. 23 00:01:25,490 --> 00:01:30,940 And H, in HLOOKUP stands for horizontal, or a search and find in a row. 24 00:01:30,940 --> 00:01:34,720 Since our data is organized in columns, we'd wanna use a VLOOKUP. 25 00:01:34,720 --> 00:01:37,460 And I'll show you how to that in the next video