This means that the second column in the table is where we will find the value to return. In this example, the third parameter is 2. A value of 1 indicates the first column in the table. The third parameter is the position number in the table where the return data can be found. The second column in the range (B1:B6) contains the value to return which is the Product value. The first column in the range (A1:A6) is used to search for the Order value of 10251. In this example, the second parameter is A1:B6 which gives us two columns to data to use in the vertical lookup - A1:A6 and B1:B6. The second parameter in the VLOOKUP function is the table or the source of data where the vertical lookup should be performed. But if the search value was text, you would need to put it in double quotes, for example: =VLOOKUP("10251", A1:B6, 2, FALSE) Second Parameter Because it is a numeric value, you can just enter the number. This is the value that the VLOOKUP will search for in the first column of the table of data. In this example, the first parameter is 10251. The first parameter in the VLOOKUP function is the value to search for in the table of data. Now, let's look at the example =VLOOKUP(10251, A1:B6, 2, FALSE) that returns a value of "Pears" and take a closer look why.
Result: "Apples" 'Returns an approximate match Result: #N/A 'Returns #N/A error (no exact match) Result: $18.60 'Returns value in 3rd column Result: "Pears" 'Returns value in 2nd column Let's explore how to use VLOOKUP as a worksheet function in Microsoft Excel.īased on the Excel spreadsheet above, the following VLOOKUP examples would return: =VLOOKUP(10251, A1:B6, 2, FALSE)
0 kommentar(er)
