Arrange data in columns B and C against a linear timeline in column A

I apologize in advance because I'm sure there's an answer to this question already, but I'm not knowledgeable enough to provide the right search terms to find it despite my best efforts.

I have data in two columns - first a Date, then a Value.

I want to put a sequential date sequence in Column A (e.g. 1/1/2018 to 12/31/2020), then paste my non-sequential data into two columns and have Excel align the data values with the timeline.

How do I get the pasted non-sequential data (Dates and their Values) to line up with the corresponding dates in Column A?

I've managed to use this formula that someone generously posted:
=IF(ISNA(MATCH(A1,B:B,0)),"",INDEX(B:B,MATCH(A1,B:B,0)))

...to get my data's Dates to align with the timeline, but I can't get the Values to do the same.

Thanks in advance for your help.

You can use this formula in B2:

=IF(ISNA(MATCH($A2,$E:$E,0)),"",VLOOKUP($A2,$E:$F,COLUMNS($E:E),0))

and copy it into C2. Then you can copy both those formulae down as far as you need to.

Hope this helps.

Pete

P.S. If you are no longer using Excel 2003, please update your profile.

Here are alternative ones.

B17 and down:

=IFERROR(--CONCAT(IF(A17=$E$2:$E$6,$E$2:$E$6,"")),"")

C17 and down:

=CONCAT(IF(A17=$E$2:$E$6,$F$2:$F$6,""))

Pete's solution does the trick nicely - thanks Pete!

Also thank you for pointing out my stale profile info - I've updated it.


Thank you to everyone who assisted - I appreciate the efforts of all the experts on this forum.

Glad to help, and thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Using a more recent version of Excel allows you to simplify the formula that I gave you:

=IFERROR(VLOOKUP($A2,$E:$F,COLUMNS($E:E),0),"")

Put this in B2, copy into C2, then copy both formulae down, as before.

Hope this helps.

Pete