How to use Vlookup (example)

< Back to Search results

 Category: [Excel]  Demo Available 

How to use Vlookup (example)




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).






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.


stars (0 Reviews)