# VLOOKUP for a range of dates

1. ## VLOOKUP for a range of dates

Is there a way such that I can combine a range of dates in the one cell so that I can use it for vlookup?

What I mean is something like this

1/1/2014-31/1/2014 100
1/2/2014-28/1/2014 96
...

Afterwards, I would then like to look up the value corresponding to the date 15/1/2014

2. ## Re: VLOOKUP for a range of dates

Why would you want to use a range like that? If your date ranges are consecutive - and in early-to-latest order - vlookup should manage ok?

What exactly are you trying to do?

can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

3. ## Re: VLOOKUP for a range of dates

Here is a sample

4. ## Re: VLOOKUP for a range of dates

Perhaps something like this? Using array formula (means when you ENTERING this formula you need to press CTRL+SHIFT+ENTER button together, dont' ENTER alone)

5. ## Re: VLOOKUP for a range of dates

Another solution is to place the start and end dates in separate columns. Since each start date is the day after the previous end date you can ignore the end date and use =VLOOKUP(F4,A1:C4,3,TRUE) - the TRUE (approximate match) means that it will select the row containing the highest date that is not greater than the one specified.
I've attached an example.

6. ## Re: VLOOKUP for a range of dates

@Skillsguy

Although the solution in #4 of azumi works and provides the answer in the conditions of your question,

I advice you to go for the offered solution in #5 of Larena.

That formula is much better to understand and therefor easier to change.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1