#How to use vlookup in excel table how to
This article will teach you how to use the VLOOKUP function. The second argument of the IFERROR function, "value_if_error" would be a VLOOKUP looking in Table2. It is a function that makes Excel search for a certain value in a column (the so called ‘table array’), in order to return a value from a different column in the same row. The first argument in the IFERROR function, "value" would be a VLOOKUP looking in Table1. For a two-table lookup, the formula would be: We are just using a combination of VLOOKUP and IFERROR. We specify the location of the table in the second argument. So, we set the first parameter as the lookup value, which is the cell H5. Here is the results from selecting Brazil from the first part of the list:Īnd here is the results from selecting Turkey from the last part of the list: In the example below, we are using the VLOOKUP function to find the value of the exact match of ID from the given table. Now I can choose any country from the drop down list that would pull from any of the tables and get the correct answer. In cell G11 I have a data validation drop down list with the 20 countries:Īnd in cell G14 I just have a formula that says =G11 so I don't need two drop down lists: So here I have the top 20 countries by population broken into two tables (Table1 & Table2):Īnd I also have them broken down into three tables (Table4, Table5, & Table6): When you get a preview, look for Download in the upper right hand corner. For tablearray (2nd argument), supply the entire List 2. You can download the file here and follow along. To build a VLOOKUP formula in its basic form, this is what you need to do: For lookupvalue (1st argument), use the topmost cell from List 1.
:max_bytes(150000):strip_icc()/vlookup-excel-examples-19fed9b244494950bae33e044a30370b.png "how to use vlookup in excel table")
In this tutorial we are going to look at how to use the VLOOKUP function when the lists are scattered across two or three tables in Excel.
0 kommentar(er)
