search for matching dates, then copy data when a match is found

[RXND]

Hello Everyone have a problem that I’m trying to solve.

Id like to match dates from column c to column A, and copy the data from column D to Column B.

I have raw data with dates( C & D ) but are not in order, or skipping some dates. I basically need a way to search through the dates, and match them with the calendar days on column A, and then copy the matching info to column B.

Any help to point me in the right direction is greatly appreciated.

Thank you

 

[RXND]

Just noted you have Excel 2019, if you get an error when using that formula, please try this one(Again, please change the range to match what is on your sheet).

=IFNA(VLOOKUP(A1,$C$1:$D$13,2,FALSE),"")

I hoe you have a good weekend as well.

Thank you, this worked for me under excel 2019

 

[smozgur]

Thank you, this worked for me under excel 2019

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.