The VLOOKUP function is used frequently in Excel for daily work. Have you ever tried to find the values in a table based on a date by using the VLOOKUP function? This article will show you an easy way to solve this problem. Let’s jump into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Generic Formula:
- To retrieve a value on a specific date from a table, you can use the VLOOKUP function.
=VLOOKUP(date,table,column_no,FALSE)
Syntax Explanations:
- VLOOKUP – This function will help to lookup data in a range or table by row. Read more on the VLOOKUP function.
- FALSE – In Excel, the FALSE function helps to return the logical value FALSE.
- Date – It is the specified date to retrieve a value.
- Table – It represents the input data from your worksheet.
- Column_No – This is the column number where the criterion value is available.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Practical Example:
Refer to the below example image, here we will show how to retrieve data based on the given date.
- First, we will give the input values in Column B and Column C.
- Then, enter the above-given formula in the formula bar section and press the ENTER key.
- Finally, we will get the result in the selected cell.
Wrap-Up:
Hope you understood how to find the value on a specified date in Excel by using the VLOOKUP function. If you have any queries/suggestions from the above article or any other article on this site, feel free to let us know. We will assist you!! Click here to know more about *Geek Excel **and Excel Formulas *!! **
Top comments (0)