How to use Vlookup (example)
Requirement:
The user has a very large sheet of dates when projects need to start and a diary from the customer.
To report to the customer when this work is done it would be better to have a mechanism to define what year & period that the project falls in (column A).
The formula the user would like looks at the date (column B), then by using a formula it looks to see what date range it falls between (columns f & G), then the output finds the correct year & period (column H).
Solution:
=VLOOKUP(B2,$F$2:$H$13,3,1)
Obtained from the OzGrid Help Forum.
Solution provided by Ingo_Ingo.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to use the VLOOKUP formula |
| How to use IF and VLOOKUP formulas together |
| How to maintain the VLOOKUP font format |
| How to insert VLOOKUP into cell with variable array |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
