1 00:00:00,350 --> 00:00:03,880 Alright, let's walk through the HLOOKUP function together. 2 00:00:03,880 --> 00:00:07,370 Okay, so here we have the data for all counties in Texas, but 3 00:00:07,370 --> 00:00:10,260 it's formatted in rows instead of columns. 4 00:00:10,260 --> 00:00:14,320 Headers down the farthest left column instead of across the top row. 5 00:00:14,320 --> 00:00:19,765 You can see we have already labeled row 8 as population, 6 00:00:19,765 --> 00:00:24,871 so in cell B8 let's type = HLOOKUP open parentheses 7 00:00:24,871 --> 00:00:28,850 then the look up value will be the county. 8 00:00:30,060 --> 00:00:34,350 Then select the three rows on the population in units tab for the range, 9 00:00:38,450 --> 00:00:43,280 And then input 3 for it to return the third row population. 10 00:00:43,280 --> 00:00:47,266 And then false, since we're looking for exact matches. 11 00:00:49,580 --> 00:00:53,080 There it is, 14,445 for population in Newton County. 12 00:00:53,080 --> 00:00:57,782 Now we can copy this formula over for the other counties.