The VLOOKUP (vertical lookup) function in Excel allows you to search for a specific value in a table and return a corresponding value from a different column in the same row. Here is a step-by-step guide on how to use the VLOOKUP function in Excel:
Create a table with the data you want to search through. Make sure that the first column of the table contains the values you want to search for (the "lookup value").
In the cell where you want the result of the lookup to appear, type the formula =VLOOKUP(
The first argument you need to provide to VLOOKUP is the lookup value. You can enter this value directly into the formula, or you can reference a cell that contains the value. For example, if the lookup value is in cell A1, you would enter A1,
The second argument is the range of cells that contains the table you want to search through. You can either enter the range directly into the formula (e.g. A1:D10) or you can name a range and use the range name (e.g. table1).
The third argument is the column number in the table that contains the value you want to return. For example, if you want to return the value in the third column of the table, you would enter 3,
The fourth argument is an optional logical value (TRUE or FALSE) that specifies whether you want an exact or approximate match. If you want an exact match, you would enter FALSE, if you want an approximate match, you would enter TRUE (default value is FALSE)
Close the formula with a closing parenthesis )
For example, the formula =VLOOKUP(A1,A1:D10,3,FALSE) would look for the value in cell A1 in the first column of the table located in the range A1:D10, and return the value in the third column of the same row.
Note: Make sure that the first column of your table is sorted in ascending order, otherwise VLOOKUP will return unexpected results.
How to use in Smartphone/Mobile phone?
The VLOOKUP function can also be used in the Excel app on a smartphone, but the steps may be slightly different due to the smaller screen size and touch interface. Here is a step-by-step guide on how to use the VLOOKUP function in Excel on a smartphone:
Open the Excel app on your smartphone and open the spreadsheet that contains the data you want to search through.
Tap on the cell where you want the result of the lookup to appear.
Tap on the "fx" button to open the formula builder.
Type "VLOOKUP" into the search bar and select it from the list of formulas.
In the function arguments, enter the lookup value. You can either enter this value directly or tap on the cell that contains the value to reference it.
Next, enter the range of cells that contains the table you want to search through. You can either enter the range directly or tap on the first cell of the table and drag your finger to select the entire table.
Enter the column number in the table that contains the value you want to return.
Tap on the "checkmark" button to apply the formula and complete the function.
Press Enter to see the result.
Note: Make sure that the first column of your table is sorted in ascending order, otherwise VLOOKUP will return unexpected results. And also, in smartphones, some of the steps may vary depending on the device and excel app you are using.
No comments:
Post a Comment