if__vlookup function by date

[xaritona89]

Hello,
Please help me.
When I have to work on Date, I often spend a lot of time working.

How to use vlookup when we have Date to consider.

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also, can you give us the sample data and expected results with XL2BB so we can copy to test with?
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[shinigamilight]

This will only work if there are 5 identical dates in Create_Date column and it will pull the 5 dates greater than or equal to the date you are searching for.

=INDEX($C$2:$C$21,SMALL((--($A$2:$A$21>=H2)*--($A$2:$A$21<=INDEX($A$2:$A$21,MATCH(1,--($A$2:$A$21>=H2),0)))*ROW($A$1:$A$20)),SUMPRODUCT(--(((--($A$2:$A$21>=H2)*--($A$2:$A$21<=INDEX($A$2:$A$21,MATCH(1,--($A$2:$A$21>=H2),0)))*ROW($A$1:$A$20)))=0))+ROW(J1)),1)

Make sure to press ctrl shift enter when executing this formula.

 

[Fluff]

Another option

=INDEX($C$2:$C$21,MATCH(1,($B$2:$B$21=G2)*($A$2:$A$21>H2),0))

which may need Ctrl Shift Enter depending on your version.