H hook up excel

University of Wisconsin KnowledgeBase

The Excel HLOOKUP Function

VLOOKUP in Excel is useful for looking for specific information in your worksheet. Learn all about it in this Excel VLOOKUP tutorial. Many of our learners have told us they want to learn how to use Excel's VLOOKUP function. VLOOKUP exdel an extremely jook tool, and learning how to use it is easier than you think! H hook up excel you start, you should understand the basics of functions.

Check out our Functions lesson from our Excel Formulas tutorial or select a specific version of Excel. VLOOKUP works hlok same in all h hook up excel of Excel, and it even ezcel in other spreadsheet applications like Google Sheets. You can download the example if you'd like to work along with this article. Basically, VLOOKUP lets you search for specific information in your spreadsheet.

For example, if you have a list of products with prices, you could search for the price of a specific item. We're going to use VLOOKUP to find the price of the Photo frame. Once you learn how to use VLOOKUP, you'll be able to use it with larger, more complex spreadsheets, and that's when h hook up excel will become truly useful.

We'll add our formula to cell E2but you can add it to any blank cell. Then type the formula name. Our arguments will need to be in parentheses, so type an open parenthesis. So far, it should look like this:. Now, we'll add our arguments. The arguments will tell VLOOKUP what to search for and where to search. The first argument is the name of the item you're searching for, which in this case is Photo frame.

Because the argument is text, we'll need to put it in double quotes:. The second argument is the cell range that contains the data. In this example, our data is in A2: As with any function, you'll need to h hook up excel a comma to separate each argument:. It's important to know that VLOOKUP will always search the first column in this range. In this example, it will search column A for "Photo frame". In some cases, you may need to move excsl columns h hook up excel so the first column contains the correct data.

B third argument is the column index number. It's simpler than it sounds: The first column in the range is 1, the second column is 2, etc. In this case, we are trying to find the price of the itemand the prices are contained in the second column. This means our third argument will be The fourth argument tells VLOOKUP whether to look for approximate matchesand it can be either TRUE or FALSE.

If it is TRUE, h hook up excel will look for approximate matches. Generally, this is only useful if the first column has numerical values that have been sorted. Because we're only looking for exact matches, the fourth argument should be FALSE. This is our last argument, so go ahead and close the parentheses:. Let's take a look at how this formula works.

It first searches vertically down the first column VLOOKUP is short for vertical lookup. When it finds "Photo frame", it moves to the second column to find the price. Are you ready for a slightly more complicated example? Let's say we have a third column that has the category for each item. This time, instead of finding the price we'll find the category. To excrl the category, we'll need to change the second and third arguments in our formula.

First, we'll change the range to A2: C16 so it includes the third column. Next, we'll change the column index number to 3 because our categories are in the third column:. Now you h hook up excel excep basics of using VLOOKUP. Although advanced users sometimes use VLOOKUP in different ways, you can do a lot with the techniques we've covered. For example, if you have a contact list you could search for someone's name to find his or her phone number. If your contact list has columns for the email address or company name, you could search for those by simply changing the second and third arguments, as we h hook up excel in our example.

The possibilities are endless! How to Use Excel's VLOOKUP Function VLOOKUP in Excel is useful for looking for specific information in your worksheet. How to use Excel's VLOOKUP function Many of our learners have told us they want to learn how to use Excel's VLOOKUP function. What exactly is VLOOKUP? About Us Who We Are Who Uses Us How to Use GCF How We've Helped Meet the Staff Our Awards Tell Your Friends!

Our Year in Resources For Educators Our Approach Teacher Guides Resources and Tools Teacher Stories Give Us Feedback! Newsroom Press Releases Media Kit Coming Soon. Help and Support FAQs Other Languages Terms of Use Request a Topic Donate Contact Us.

HLOOKUP() in Excel - how to use it and edit it. Walkthrough explanation.

Leave a comment