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

 

[Coyotex3]

Maybe this will work.

Paste this in cell B1. Make sure to change the range to match the length of the ranges on your sheet.

IFNA(XLOOKUP(A1,$C$1:$C$13,$D$1:$D$13),"")

It will return something like this:

 

[RXND]

Thank you so much. This was exactly what I was looking for.

Have a good weekend !

 

[Coyotex3]

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.

 

[Fluff]

FYI there is no need for the ifna function as xlookup can handle that itself like

=XLOOKUP(A1,$C$1:$C$13,$D$1:$D$13,"")

 

[Fluff]

This was exactly what I was looking for.

In that case what version of Excel are you using, as 2019 doesn't have xlookup?

 

[Coyotex3]

FYI there is no need for the ifna function as xlookup can handle that itself like

=XLOOKUP(A1,$C$1:$C$13,$D$1:$D$13,"")

Thanks @Fluff. Adding this to the toolbox!

 

[RXND]

Maybe this will work.

Paste this in cell B1. Make sure to change the range to match the length of the ranges on your sheet.

IFNA(XLOOKUP(A1,$C$1:$C$13,$D$1:$D$13),"")

It will return something like this:

 

[RXND]

In that case what version of Excel are you using, as 2019 doesn't have xlookup?

oh Im using 2019. The result that you posted was the result that im looking for. How can I run something similar in the 2019 version?

 

[Coyotex3]

oh Im using 2019. The result that you posted was the result that im looking for. How can I run something similar in the 2019 version?

Try the formula on Post #4.