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
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.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Here is a sample
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)
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.
@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.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks