updating business day to calendar day values...

[sadams1]

finally crying "uncle!" on this...after trying advanced filters, vlookups & various other avenues that didn't work, all I'll like to do is something seemingly simple...search a column of business dates to match in a column of calendar dates then paste the value from the business to calendar in the next column. This is for market research...here's a 2 week table:

am I making this too difficult or am I approaching it wrong?

All_Dates_Business	Close
03/20/20​	19,174
03/19/20​	20,087
03/18/20​	19,899
03/17/20​	21,237
03/16/20​	20,189
03/13/20​	23,186
03/12/20​	21,201
03/11/20​	23,553
03/10/20​	25,018
03/09/20​	23,851
All_Dates_Calendar
03/20/20​	match this value in the "calendar" range to value in "business" range THEN paste value from "business close" into this cell
03/19/20​	match this value in the "calendar" range to value in "business" range THEN paste value from "business close" into this cell
03/18/20​	match this value in the "calendar" range to value in "business" range THEN paste value from "business close" into this cell
03/17/20​	match this value in the "calendar" range to value in "business" range THEN paste value from "business close" into this cell
03/16/20​	match this value in the "calendar" range to value in "business" range THEN paste value from "business close" into this cell
03/15/20​	match this value in the "calendar" range to value in "business" range THEN paste value from "business close" into this cell
03/14/20​	match this value in the "calendar" range to value in "business" range THEN paste value from "business close" into this cell
03/13/20​	match this value in the "calendar" range to value in "business" range THEN paste value from "business close" into this cell
03/12/20​	match this value in the "calendar" range to value in "business" range THEN paste value from "business close" into this cell
03/11/20​	match this value in the "calendar" range to value in "business" range THEN paste value from "business close" into this cell
03/10/20​	match this value in the "calendar" range to value in "business" range THEN paste value from "business close" into this cell
03/09/20​	match this value in the "calendar" range to value in "business" range THEN paste value from "business close" into this cell
03/08/20​	match this value in the "calendar" range to value in "business" range THEN paste value from "business close" into this cell
03/07/20​	match this value in the "calendar" range to value in "business" range THEN paste value from "business close" into this cell

 

[Beyond_avarice]

Select a cell and make one of your business days equal to one of your calendar days (eg =A1=D1) If the value you get is false, then you may have a Data type issue (text vs Date). You may have trim issues (spaces on either side of your dates. Did you copy your business day information off of a website?. One of your dates may be hiding a fractional day (eg 3/20/2020 5:00:00 PM vs 3/20/2020).

 

[Peter_SSs]

after trying .... vlookups

If I have understood correctly, that should work for you. Is this what you mean?
Note that my dates are in d/m/y format.

20 03 23.xlsm
	A	B
1	All_Dates_Business	Close
2	20/03/2020	19,174
3	19/03/2020	20,087
4	18/03/2020	19,899
5	17/03/2020	21,237
6	16/03/2020	20,189
7	13/03/2020	23,186
8	12/03/2020	21,201
9	11/03/2020	23,553
10	10/03/2020	25,018
11	9/03/2020	23,851
12
13
14	All_Dates_Calendar
15	20/03/2020	19,174
16	19/03/2020	20,087
17	18/03/2020	19,899
18	17/03/2020	21,237
19	16/03/2020	20,189
20	15/03/2020
21	14/03/2020
22	13/03/2020	23,186
23	12/03/2020	21,201
24	11/03/2020	23,553
25	10/03/2020	25,018
26	9/03/2020	23,851
27	8/03/2020
28	7/03/2020
Lookup

Cell Formulas
Range	Formula
B15:B28	B15	=IFERROR(VLOOKUP(A15,A$2:B$11,2,0),"")

 

[sadams1]

If I have understood correctly, that should work for you. Is this what you mean?
Note that my dates are in d/m/y format.

Wow...can't thank you enough for this.

 

[Peter_SSs]

Wow...can't thank you enough for this.

You just did.