If Date in Cell matches a Date in a range of cells

[dfelmey]

	A	B	C	D
1	Withdraw Date	Withdraw Amt	Daily Date (from the 1st to EOM)- I change C1 to the first each month)
2	8/15/2018	$(1000)	9/1/2018
3	8/25/2018		9/2/2018	($500)
4	9/2/2018	($500)	9/3/2018
5	9/4/2018	($2500)	9/4/2018	($2500)
6	9/5/2018	($800)	9/5/2018	($800)
7	9/8/2018	($5000)	9/6/2018
8	9/9/2018	($4000)	9/7/2018
9			9/8/2018	($5000)
10			9/9/2018	($4000)
11			9/10/2018
12			9/11/2018
13			9/12/2018
14			9/13//2018
15	...this row will continue month after month, Not Reset on the 1st		...All the way to 9/30/2018

<tbody>
</tbody>

I need the formula for Row D that shows the amount of the withdraw from Row B on the corresponding date. (ie, on 9/4/2018 show the $2500 withdraw from B3 in D5. -- On 9/8/2018 show the withdraw ($5000) from B7 on D9).

Let me know if any more clarification is needed.

Thank you in advance for your time.

 

[Fluff]

Try
=IFERROR(INDEX(A$2:B$14,MATCH(C2,A$2:A$14,0),2),"")

 

[dfelmey]

Sorry Fluff, that didn't work, the formula result is $0.00. It puts the $0.00 in the correct cell corresponding cell, it just does not put the value from Column B. What can I change to fix the $0.00? Thanks again

 

[Fluff]

This is the result I got with your data

Excel 2013/2016
	A	B	C	D
1	Withdraw Date	Withdraw Amt	Daily Date (from the 1st to EOM)- I change C1 to the first each month)	D
2	15/08/2018	$(1000)	01/09/2018
3	25/08/2018		02/09/2018	($500)
4	02/09/2018	($500)	03/09/2018
5	04/09/2018	($2500)	04/09/2018	($2500)
6	05/09/2018	($800)	05/09/2018	($800)
7	08/09/2018	($5000)	06/09/2018
8	09/09/2018	($4000)	07/09/2018
9			08/09/2018	($5000)
10			09/09/2018	($4000)
11			10/09/2018
12			11/09/2018
13			12/09/2018
14			13/09/2018
Sheet1

Cell Formulas
Range	Formula
D2	=IFERROR(INDEX(A$2:B$14,MATCH(C2,A$2:A$14,0),2),"")

 

[dfelmey]

Thank you, I got mine to work. My spreadsheet has Column A and B Merged, so I had to just adjust to index A:C and give results for column 3 not 2. Thank you again for your assistance!!!

 

[Fluff]

Glad you got it sorted & thanks for the feedback