Cell range to search: all highlighted cells selected as a range to search through. 
You could use a static "January" value or use the A4 reference that points to a cell with the "January" value. For instance, you might want to perform a lookup for January's rent payment.
Data to search for: this can be a cell or a value that you want to find. The VLOOKUP function uses the following syntax: They also provide a way to perform a lookup and display data dynamically should the value in the lookup column change. These lookup functions make it easier to find values among hundreds (even thousands) of records in a spreadsheet instead of searching for a value using a simple file search. The first column is searched for a given value, and then the adjacent cell to the right of the column is the data used to either calculate a result or just display the lookup result in the spreadsheet. It's important to remember that lookup functions require two columns (or rows when using HLOOKUP). These three functions are valuable when you need to search for data and display a result in a separate cell. The traditional VLOOKUP function searches a column for data, and the HLOOKUP function searches a row for data. 
The LOOKUP function was added in later versions, which gives users more flexibility with data lookups. Excel has three ways to search for data within a spreadsheet: vertical, horizontal and both.
0 kommentar(er)
