VLookup with an if statement

[tonguencheek]

I'm looking for a way to use a vlookup in combination with an if statement (or other method to solve for my ask). I will have a table of dates with values next to them. Then in another section I will have a longer list of dates with the formula I'm looking for help with next to each date.

What I would like is a formula (in column B in below) that looks at the first table (in D1-E3 in below) and if the date next to the formula is found, then return the value next to it in that table. Otherwise return the value above the cell with the formula. Below shows the results I would want with the formula in column B.

	A	B	C	D	E
1	05/31/18	3		06/01/18	5
2	06/01/18	5		07/15/18	10
3	06/15/18	5		08/25/18	15
4	07/15/18	10
5

<tbody>
</tbody>

Thanks all!

 

[Oaktree]

B2=IFNA(VLOOKUP(A2,D$1:E$3,2,0),B1) copied down

 

[tonguencheek]

B2=IFNA(VLOOKUP(A2,D$1:E$3,2,0),B1) copied down

Thanks for the response. I am getting #name as a result?

 

[Joe4]

I am guessing that you are using an older version of Excel that does not have the IFNA function (introduced in Excel 2013)

If that case, perhaps try:

=IFERROR(VLOOKUP(A2,D$1:E$3,2,0),B1)

or

=IF(ISNA(VLOOKUP(A2,D$1:E$3,2,0)),B1,VLOOKUP(A2,D$1:E$3,2,0))