VLOOKUP or INDEX or MATCH or INDIRECT

[MrDB4Excel]

I have 2 Excel workbooks. One is a Power Query, getting data from a website, and in the second workbook, I need to capture the history of data query from the first. This may seem confusing so a better explanation is in order.

The Power Query workbook (USDtoCZKForecast-2021pq.xlsx) looks to USD/CZK Forex Rate Forecast, Dollar to Koruna Predictons by days: 2021

Every day this website gets exchange rate data for an entire year, but each day it drops off the previous day’s data thus unless that previous data is somehow saved in a workbook it is lost. This only occurs for the current month, in this case, because it is February then February’s previous day’s data is lost on the data refresh. March through December remains intact because it is future data and remains until the next month comes into view as the current month, e.g. March.

This is what I want the second workbook to do. On a daily basis as I open USDtoCZKForecast-2021pq.xlsx and refresh the Power Query tab, called 2021pq, and prior to the 2021pq data refresh, I want the previous day’s values to get inserted, copied into the second workbook, 02-USDtoCZKHistory-Feb.xlsx.

Further explanation regarding USDtoCZKForecast-2021pq.xlsx is due. The 2021pq Tab only refreshes data for months subsequent to the current month as seen in the XL2BB view of same. This means then that a subsequent Power Query is needed for the current month, which I have named UpcomingDays, which incidentally is what this website calls this set of data. It is this set of queried data that drops off the previous day’s data and is why I want to have a second workbook capturing this data before it is lost.

Any help will be greatly appreciated as I have scoured the web looking for something to incorporate but no luck. I have viewed YouTubes and other information sites regarding VLOOKUP, INDEX, MATCH, & INDIRECT or any combination thereof and still come up empty-handed. It all is so confusing.

An XL2BB view of each workbook follows. I do not know why some are shown with lines thru the data.
These next four are from USDtoCZKForecast-2021pq.xlsx

USDtoCZKForecast-2021pq.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
2	Date	Average Rate	Minimum Rate	Maximum Rate	MIN & MAX Average	CZK Per Min/Max Average Rate		CZK Per Min Rate	CZK Per Max Rate
3	2021 February	21.3770	21.2900	21.4657	21.3779	58,578.86 Kč		58,338.11 Kč	58,819.60 Kč	Rate	Minimum Rate	Maximum Rate
4	Wednesday-03 Feb 2021	21.3750	21.3370	21.4140	21.3755	58,572.40 Kč		58,466.90 Kč	58,677.89 Kč	Rate: 21.375	Min: 21.337	Max: 21.414	2021 February
5	Thursday-04 Feb 2021	21.3940	21.3540	21.4360	21.3950	58,625.83 Kč		58,513.48 Kč	58,738.18 Kč	Rate: 21.394	Min: 21.354	Max: 21.436	2021 February
6	Friday-05 Feb 2021	21.3940	21.3510	21.4360	21.3935	58,621.72 Kč		58,505.26 Kč	58,738.18 Kč	Rate: 21.394	Min: 21.351	Max: 21.436	2021 February
7	Saturday-06 Feb 2021	21.3980	21.3510	21.4440	21.3975	58,632.68 Kč		58,505.26 Kč	58,760.10 Kč	Rate: 21.398	Min: 21.351	Max: 21.444	2021 February
8	Sunday-07 Feb 2021	21.3830	21.3260	21.4360	21.3810	58,587.47 Kč		58,436.76 Kč	58,738.18 Kč	Rate: 21.383	Min: 21.326	Max: 21.436	2021 February
9	Monday-08 Feb 2021	21.4370	21.3720	21.5050	21.4385	58,745.03 Kč		58,562.81 Kč	58,927.25 Kč	Rate: 21.437	Min: 21.372	Max: 21.505	2021 February
10	Tuesday-09 Feb 2021	21.3870	21.3190	21.4610	21.3900	58,612.13 Kč		58,417.58 Kč	58,806.68 Kč	Rate: 21.387	Min: 21.319	Max: 21.461	2021 February
11	Wednesday-10 Feb 2021	21.3380	21.2590	21.4160	21.3375	58,468.27 Kč		58,253.17 Kč	58,683.37 Kč	Rate: 21.338	Min: 21.259	Max: 21.416	2021 February
12	Thursday-11 Feb 2021	21.3570	21.2550	21.4530	21.3540	58,513.48 Kč		58,242.21 Kč	58,784.76 Kč	Rate: 21.357	Min: 21.255	Max: 21.453	2021 February
13	Friday-12 Feb 2021	21.3570	21.2520	21.4630	21.3575	58,523.07 Kč		58,233.99 Kč	58,812.16 Kč	Rate: 21.357	Min: 21.252	Max: 21.463	2021 February
14	Saturday-13 Feb 2021	21.3620	21.2370	21.4920	21.3645	58,542.26 Kč		58,192.88 Kč	58,891.63 Kč	Rate: 21.362	Min: 21.237	Max: 21.492	2021 February
15	Sunday-14 Feb 2021	21.3460	21.2150	21.4860	21.3505	58,503.89 Kč		58,132.60 Kč	58,875.19 Kč	Rate: 21.346	Min: 21.215	Max: 21.486	2021 February
16	Monday-15 Feb 2021	21.4000	21.2460	21.5510	21.3985	58,635.42 Kč		58,217.55 Kč	59,053.30 Kč	Rate: 21.400	Min: 21.246	Max: 21.551	2021 February
17	Tuesday-16 Feb 2021	21.3500	21.1860	21.5270	21.3565	58,520.33 Kč		58,053.14 Kč	58,987.53 Kč	Rate: 21.350	Min: 21.186	Max: 21.527	2021 February
UPComing2

USDtoCZKForecast-2021pq.xlsx
	A	B	C	D	E
1	Column1	Date	Average rate (≈)	Minimum rate (⇓)	Maximum rate (⇑)
2	March	03/01/2021	≈21.567	⇓21.567	⇑22.764
3	March	03/02/2021	≈21.566	⇓21.566	⇑22.738
4	March	03/03/2021	≈21.557	⇓21.557	⇑22.727
5	March	03/04/2021	≈21.547	⇓21.547	⇑22.666
6	March	03/05/2021	≈21.541	⇓21.541	⇑22.626
7	March	03/06/2021	≈21.531	⇓21.531	⇑22.732
8	March	03/07/2021	≈21.524	⇓21.524	⇑22.705
9	March	03/08/2021	≈21.515	⇓21.515	⇑22.795
10	March	03/09/2021	≈21.515	⇓21.515	⇑22.728
11	March	03/10/2021	≈21.507	⇓21.507	⇑22.716
12	March	03/11/2021	≈21.499	⇓21.499	⇑22.677
13	March	03/12/2021	≈21.496	⇓21.496	⇑22.628
14	March	03/13/2021	≈21.489	⇓21.489	⇑22.715
15	March	03/14/2021	≈21.486	⇓21.486	⇑22.732
16	March	03/15/2021	≈21.481	⇓21.481	⇑22.661
17	March	03/16/2021	≈21.485	⇓21.485	⇑22.658
18	March	03/17/2021	≈21.482	⇓21.482	⇑22.754
19	March	03/18/2021	≈21.478	⇓21.478	⇑22.643
20	March	03/19/2021	≈21.480	⇓21.480	⇑22.697
21	March	03/20/2021	≈21.477	⇓21.477	⇑22.630
22	March	03/21/2021	≈21.479	⇓21.479	⇑22.744
23	March	03/22/2021	≈21.477	⇓21.477	⇑22.621
24	March	03/23/2021	≈21.486	⇓21.486	⇑22.762
25	March	03/24/2021	≈21.485	⇓21.485	⇑22.694
26	March	03/25/2021	≈21.485	⇓21.485	⇑22.589
27	March	03/26/2021	≈21.489	⇓21.489	⇑22.579
28	March	03/27/2021	≈21.488	⇓21.488	⇑22.681
29	March	03/28/2021	≈21.491	⇓21.491	⇑22.733
30	March	03/29/2021	≈21.490	⇓21.490	⇑22.674
31	March	03/30/2021	≈21.498	⇓21.498	⇑22.706
32	March	03/31/2021	≈21.497	⇓21.497	⇑22.673
33	April	04/01/2021	≈21.495	⇓21.495	⇑22.774
34	April	04/02/2021	≈21.497	⇓21.497	⇑22.653
35	April	04/03/2021	≈21.493	⇓21.493	⇑22.726
36	April	04/04/2021	≈21.493	⇓21.493	⇑22.712
37	April	04/05/2021	≈21.489	⇓21.489	⇑22.746
38	April	04/06/2021	≈21.493	⇓21.493	⇑22.662
39	April	04/07/2021	≈21.487	⇓21.487	⇑22.660
2021pq

USDtoCZKForecast-2021pq.xlsx
	A	B	C	D
1	Date	Rate	Min Rate	Max Rate
2	02/03/2021	Rate: 21.375	Min: 21.337	Max: 21.414
3	02/04/2021	Rate: 21.394	Min: 21.354	Max: 21.436
4	02/05/2021	Rate: 21.394	Min: 21.351	Max: 21.436
5	02/06/2021	Rate: 21.398	Min: 21.351	Max: 21.444
6	02/07/2021	Rate: 21.383	Min: 21.326	Max: 21.436
7	02/08/2021	Rate: 21.437	Min: 21.372	Max: 21.505
8	02/09/2021	Rate: 21.387	Min: 21.319	Max: 21.461
9	02/10/2021	Rate: 21.338	Min: 21.259	Max: 21.416
10	02/11/2021	Rate: 21.357	Min: 21.255	Max: 21.453
11	02/12/2021	Rate: 21.357	Min: 21.252	Max: 21.463
12	02/13/2021	Rate: 21.362	Min: 21.237	Max: 21.492
13	02/14/2021	Rate: 21.346	Min: 21.215	Max: 21.486
14	02/15/2021	Rate: 21.400	Min: 21.246	Max: 21.551
15	02/16/2021	Rate: 21.350	Min: 21.186	Max: 21.527
UpcomingDays

USDtoCZKForecast-2021pq.xlsx
	A	B	C	D
1	Date	Rate	Minimum Rate	Maximum Rate
2	Wednesday-03 Feb 2021	Rate: 21.375	Min: 21.337	Max: 21.414
3	Thursday-04 Feb 2021	Rate: 21.394	Min: 21.354	Max: 21.436
4	Friday-05 Feb 2021	Rate: 21.394	Min: 21.351	Max: 21.436
5	Saturday-06 Feb 2021	Rate: 21.398	Min: 21.351	Max: 21.444
6	Sunday-07 Feb 2021	Rate: 21.383	Min: 21.326	Max: 21.436
7	Monday-08 Feb 2021	Rate: 21.437	Min: 21.372	Max: 21.505
8	Tuesday-09 Feb 2021	Rate: 21.387	Min: 21.319	Max: 21.461
9	Wednesday-10 Feb 2021	Rate: 21.338	Min: 21.259	Max: 21.416
10	Thursday-11 Feb 2021	Rate: 21.357	Min: 21.255	Max: 21.453
11	Friday-12 Feb 2021	Rate: 21.357	Min: 21.252	Max: 21.463
12	Saturday-13 Feb 2021	Rate: 21.362	Min: 21.237	Max: 21.492
13	Sunday-14 Feb 2021	Rate: 21.346	Min: 21.215	Max: 21.486
14	Monday-15 Feb 2021	Rate: 21.400	Min: 21.246	Max: 21.551
15	Tuesday-16 Feb 2021	Rate: 21.350	Min: 21.186	Max: 21.527
Upcoming-Days

These next four are from 02-USDtoCZKHistory-Feb.xlsx

Date	Average Rate	Minimum Rate	Maximum Rate	MIN & MAX Average	CZK Per Min/Max Average Rate		CZK Per Min Rate	CZK Per Max Rate
2021 February	21.8902	21.7884	21.9917	21.8901	59,982.41 Kč		59,703.89 Kč	60,260.93 Kč	Rate	Minimum Rate	Maximum Rate
Monday-01 Feb 2021	21.2370	21.1440	21.3370	21.2405	58,202.47 Kč		57,938.05 Kč	58,466.90 Kč	Rate: 21.237	Min: 21.144	Max: 21.337	2021 February
Tuesday-02 Feb 2021	21.1630	21.0590	21.2830	21.1710	58,012.03 Kč		57,705.13 Kč	58,318.93 Kč	Rate: 21.163	Min: 21.059	Max: 21.283	2021 February
Wednesday-03 Feb 2021	21.0670	20.9400	21.2140	21.0770	57,754.46 Kč		57,379.06 Kč	58,129.86 Kč	Rate: 21.067	Min: 20.940	Max: 21.214	2021 February
Thursday-04 Feb 2021	21.0610	20.9180	21.2330	21.0755	57,750.35 Kč		57,318.77 Kč	58,181.92 Kč	Rate: 21.061	Min: 20.918	Max: 21.233	2021 February
Friday-05 Feb 2021	21.0680	20.9000	21.2710	21.0855	57,777.75 Kč		57,269.45 Kč	58,286.05 Kč	Rate: 21.068	Min: 20.900	Max: 21.271	2021 February
Saturday-06 Feb 2021	21.0630	20.8650	21.2800	21.0725	57,742.13 Kč		57,173.54 Kč	58,310.71 Kč	Rate: 21.063	Min: 20.865	Max: 21.280	2021 February
Sunday-07 Feb 2021	21.0240	20.8060	21.2710	21.0385	57,648.96 Kč		57,011.87 Kč	58,286.05 Kč	Rate: 21.024	Min: 20.806	Max: 21.271	2021 February
Monday-08 Feb 2021	21.0160	20.7720	21.2940	21.0330	57,633.89 Kč		56,918.71 Kč	58,349.07 Kč	Rate: 21.016	Min: 20.772	Max: 21.294	2021 February
Tuesday-09 Feb 2021	21.3870	21.3190	21.4610	21.3900	58,612.13 Kč		58,417.58 Kč	58,806.68 Kč	Rate: 21.387	Min: 21.319	Max: 21.461	2021 February
Wednesday-10 Feb 2021	21.3380	21.2590	21.4160	21.3375	58,468.27 Kč		58,253.17 Kč	58,683.37 Kč	Rate: 21.338	Min: 21.259	Max: 21.416	2021 February
Thursday-11 Feb 2021	21.3570	21.2550	21.4530	21.3540	58,513.48 Kč		58,242.21 Kč	58,784.76 Kč	Rate: 21.357	Min: 21.255	Max: 21.453	2021 February
Friday-12 Feb 2021	21.3570	21.2520	21.4630	21.3575	58,523.07 Kč		58,233.99 Kč	58,812.16 Kč	Rate: 21.357	Min: 21.252	Max: 21.463	2021 February
Saturday-13 Feb 2021	21.3620	21.2370	21.4920	21.3645	58,542.26 Kč		58,192.88 Kč	58,891.63 Kč	Rate: 21.362	Min: 21.237	Max: 21.492	2021 February
Sunday-14 Feb 2021	21.3460	21.2150	21.4860	21.3505	58,503.89 Kč		58,132.60 Kč	58,875.19 Kč	Rate: 21.346	Min: 21.215	Max: 21.486	2021 February
Monday-15 Feb 2021	21.4000	21.2460	21.5510	21.3985	58,635.42 Kč		58,217.55 Kč	59,053.30 Kč	Rate: 21.400	Min: 21.246	Max: 21.551	2021 February
Tuesday-16 Feb 2021	21.3500	21.1860	21.5270	21.3565	58,520.33 Kč		58,053.14 Kč	58,987.53 Kč	Rate: 21.350	Min: 21.186	Max: 21.527	2021 February
Wednesday-17 Feb 2021	21.5190	21.3080	21.7570	21.5325	59,002.60 Kč		58,387.44 Kč	59,617.77 Kč	Rate: 21.519	Min: 21.308	Max: 21.757	2021 February

02-USDtoCZKHistory-Feb.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
2	Date	Average Rate	Minimum Rate	Maximum Rate	MIN & MAX Average	CZK Per Min/Max Average Rate		CZK Per Min Rate	CZK Per Max Rate
3	2021 February	21.5591	21.4658	21.6494	21.5576	59,071.40 Kč		58,819.79 Kč	59,323.01 Kč	Rate	Minimum Rate	Maximum Rate
4	Thursday-04 Feb 2021	21.5360	21.4970	21.5760	21.5365	59,013.56 Kč		58,905.33 Kč	59,121.80 Kč	Rate: 21.536	Min: 21.497	Max: 21.576	2021 February
5	Friday-05 Feb 2021	21.5380	21.4970	21.5780	21.5375	59,016.30 Kč		58,905.33 Kč	59,127.28 Kč	Rate: 21.538	Min: 21.497	Max: 21.578	2021 February
6	Saturday-06 Feb 2021	21.5500	21.5070	21.5970	21.5520	59,056.04 Kč		58,932.73 Kč	59,179.34 Kč	Rate: 21.550	Min: 21.507	Max: 21.597	2021 February
7	Sunday-07 Feb 2021	21.5470	21.4960	21.5980	21.5470	59,042.34 Kč		58,902.59 Kč	59,182.08 Kč	Rate: 21.547	Min: 21.496	Max: 21.598	2021 February
8	Monday-08 Feb 2021	21.5930	21.5330	21.6470	21.5900	59,160.16 Kč		59,003.97 Kč	59,316.35 Kč	Rate: 21.593	Min: 21.533	Max: 21.647	2021 February
9	Tuesday-09 Feb 2021	21.5780	21.5120	21.6410	21.5765	59,123.17 Kč		58,946.43 Kč	59,299.91 Kč	Rate: 21.578	Min: 21.512	Max: 21.641	2021 February
10	Wednesday-10 Feb 2021	21.5390	21.4670	21.6110	21.5390	59,020.41 Kč		58,823.12 Kč	59,217.71 Kč	Rate: 21.539	Min: 21.467	Max: 21.611	2021 February
11	Thursday-11 Feb 2021	21.5450	21.4590	21.6300	21.5445	59,035.48 Kč		58,801.20 Kč	59,269.77 Kč	Rate: 21.545	Min: 21.459	Max: 21.630	2021 February
12	Friday-12 Feb 2021	21.5470	21.4480	21.6450	21.5465	59,040.97 Kč		58,771.06 Kč	59,310.87 Kč	Rate: 21.547	Min: 21.448	Max: 21.645	2021 February
13	Saturday-13 Feb 2021	21.5600	21.4460	21.6700	21.5580	59,072.48 Kč		58,765.58 Kč	59,379.38 Kč	Rate: 21.560	Min: 21.446	Max: 21.670	2021 February
14	Sunday-14 Feb 2021	21.5570	21.4280	21.6820	21.5550	59,064.26 Kč		58,716.26 Kč	59,412.26 Kč	Rate: 21.557	Min: 21.428	Max: 21.682	2021 February
15	Monday-15 Feb 2021	21.6020	21.4550	21.7500	21.6025	59,194.41 Kč		58,790.24 Kč	59,598.59 Kč	Rate: 21.602	Min: 21.455	Max: 21.750	2021 February
16	Tuesday-16 Feb 2021	21.5870	21.4190	21.7450	21.5820	59,138.24 Kč		58,691.59 Kč	59,584.89 Kč	Rate: 21.587	Min: 21.419	Max: 21.745	2021 February
17	Wednesday-17 Feb 2021	21.5480	21.3570	21.7220	21.5395	59,021.78 Kč		58,521.70 Kč	59,521.86 Kč	Rate: 21.548	Min: 21.357	Max: 21.722	2021 February
FEBpq3

02-USDtoCZKHistory-Feb.xlsx
	A	B	C	D
1	Date	Rate	Minimum Rate	Maximum Rate
2	Thursday-04 Feb 2021	Rate: 21.536	Min: 21.497	Max: 21.576
3	Friday-05 Feb 2021	Rate: 21.538	Min: 21.497	Max: 21.578
4	Saturday-06 Feb 2021	Rate: 21.550	Min: 21.507	Max: 21.597
5	Sunday-07 Feb 2021	Rate: 21.547	Min: 21.496	Max: 21.598
6	Monday-08 Feb 2021	Rate: 21.593	Min: 21.533	Max: 21.647
7	Tuesday-09 Feb 2021	Rate: 21.578	Min: 21.512	Max: 21.641
8	Wednesday-10 Feb 2021	Rate: 21.539	Min: 21.467	Max: 21.611
9	Thursday-11 Feb 2021	Rate: 21.545	Min: 21.459	Max: 21.630
10	Friday-12 Feb 2021	Rate: 21.547	Min: 21.448	Max: 21.645
11	Saturday-13 Feb 2021	Rate: 21.560	Min: 21.446	Max: 21.670
12	Sunday-14 Feb 2021	Rate: 21.557	Min: 21.428	Max: 21.682
13	Monday-15 Feb 2021	Rate: 21.602	Min: 21.455	Max: 21.750
14	Tuesday-16 Feb 2021	Rate: 21.587	Min: 21.419	Max: 21.745
15	Wednesday-17 Feb 2021	Rate: 21.548	Min: 21.357	Max: 21.722
FEBpq2

02-USDtoCZKHistory-Feb.xlsx
	A	B	C	D
1	Date	Rate	Min Rate	Max Rate
2	02/04/2021	Rate: 21.536	Min: 21.497	Max: 21.576
3	02/05/2021	Rate: 21.538	Min: 21.497	Max: 21.578
4	02/06/2021	Rate: 21.550	Min: 21.507	Max: 21.597
5	02/07/2021	Rate: 21.547	Min: 21.496	Max: 21.598
6	02/08/2021	Rate: 21.593	Min: 21.533	Max: 21.647
7	02/09/2021	Rate: 21.578	Min: 21.512	Max: 21.641
8	02/10/2021	Rate: 21.539	Min: 21.467	Max: 21.611
9	02/11/2021	Rate: 21.545	Min: 21.459	Max: 21.630
10	02/12/2021	Rate: 21.547	Min: 21.448	Max: 21.645
11	02/13/2021	Rate: 21.560	Min: 21.446	Max: 21.670
12	02/14/2021	Rate: 21.557	Min: 21.428	Max: 21.682
13	02/15/2021	Rate: 21.602	Min: 21.455	Max: 21.750
14	02/16/2021	Rate: 21.587	Min: 21.419	Max: 21.745
15	02/17/2021	Rate: 21.548	Min: 21.357	Max: 21.722
FEBpq

 

[MrDB4Excel]

I don't know how to delete this question and yet redo it with another alternative request for action. So following is my redo.
Perhaps a simpler alternative would be to acquire data from an entire row using VLOOKUP or XLOOKUP?

This it seems could all happen in only one file 02-USDtoCZKHistory-Feb.xlsx using a Helper Sheet which contains an equals the date from the last row in the Power Query “FEBpq” with this Power Query always only getting the 14 days subsequent to today’s date as the term “Upcoming Days” indicates. So for example, today’s date is February 3 so the query for Upcoming Days only gets data for February 4 through February 17, with February 17 being the last row of data in the query.

So on the Helper Sheet is the formula =FEBpq2!A15 which then gets the date of the last row. Then the formula is to get all entries in that row that follows from seeing this date as indicated by =FEBpq2!A15. In this case for today, that date shown is Wednesday-17 Feb 2021 which is 14 days hence today February 3. The tricky part is getting the data from the last row in another sheet, FEBpq3, which is looking to sheet FEBpq2 which in turn gets its data from the query FEBpq.

This is the part I am having trouble understanding, see the attached XL2BB Views.

02-USDtoCZKHistory-Feb.xlsx
	A	B	C	D
1	=B1	=TEXT(C1,"mmmm")	=TODAY()	=TEXT(EDATE(TODAY(),1),"mmmm")
2
3	February	February	Wednesday-03 Feb 2021	March
4
5			Wednesday-17 Feb 2021
6
7			Wednesday-17 Feb 2021
HelperSheet

02-USDtoCZKHistory-Feb.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
2	Date	Average Rate	Minimum Rate	Maximum Rate	MIN & MAX Average	CZK Per Min/Max Average Rate		CZK Per Min Rate	CZK Per Max Rate
3	2021 February	21.5591	21.4658	21.6494	21.5576	59,071.40 Kč		58,819.79 Kč	59,323.01 Kč	Rate	Minimum Rate	Maximum Rate
4	Thursday-04 Feb 2021	21.5360	21.4970	21.5760	21.5365	59,013.56 Kč		58,905.33 Kč	59,121.80 Kč	Rate: 21.536	Min: 21.497	Max: 21.576	2021 February
5	Friday-05 Feb 2021	21.5380	21.4970	21.5780	21.5375	59,016.30 Kč		58,905.33 Kč	59,127.28 Kč	Rate: 21.538	Min: 21.497	Max: 21.578	2021 February
6	Saturday-06 Feb 2021	21.5500	21.5070	21.5970	21.5520	59,056.04 Kč		58,932.73 Kč	59,179.34 Kč	Rate: 21.550	Min: 21.507	Max: 21.597	2021 February
7	Sunday-07 Feb 2021	21.5470	21.4960	21.5980	21.5470	59,042.34 Kč		58,902.59 Kč	59,182.08 Kč	Rate: 21.547	Min: 21.496	Max: 21.598	2021 February
8	Monday-08 Feb 2021	21.5930	21.5330	21.6470	21.5900	59,160.16 Kč		59,003.97 Kč	59,316.35 Kč	Rate: 21.593	Min: 21.533	Max: 21.647	2021 February
9	Tuesday-09 Feb 2021	21.5780	21.5120	21.6410	21.5765	59,123.17 Kč		58,946.43 Kč	59,299.91 Kč	Rate: 21.578	Min: 21.512	Max: 21.641	2021 February
10	Wednesday-10 Feb 2021	21.5390	21.4670	21.6110	21.5390	59,020.41 Kč		58,823.12 Kč	59,217.71 Kč	Rate: 21.539	Min: 21.467	Max: 21.611	2021 February
11	Thursday-11 Feb 2021	21.5450	21.4590	21.6300	21.5445	59,035.48 Kč		58,801.20 Kč	59,269.77 Kč	Rate: 21.545	Min: 21.459	Max: 21.630	2021 February
12	Friday-12 Feb 2021	21.5470	21.4480	21.6450	21.5465	59,040.97 Kč		58,771.06 Kč	59,310.87 Kč	Rate: 21.547	Min: 21.448	Max: 21.645	2021 February
13	Saturday-13 Feb 2021	21.5600	21.4460	21.6700	21.5580	59,072.48 Kč		58,765.58 Kč	59,379.38 Kč	Rate: 21.560	Min: 21.446	Max: 21.670	2021 February
14	Sunday-14 Feb 2021	21.5570	21.4280	21.6820	21.5550	59,064.26 Kč		58,716.26 Kč	59,412.26 Kč	Rate: 21.557	Min: 21.428	Max: 21.682	2021 February
15	Monday-15 Feb 2021	21.6020	21.4550	21.7500	21.6025	59,194.41 Kč		58,790.24 Kč	59,598.59 Kč	Rate: 21.602	Min: 21.455	Max: 21.750	2021 February
16	Tuesday-16 Feb 2021	21.5870	21.4190	21.7450	21.5820	59,138.24 Kč		58,691.59 Kč	59,584.89 Kč	Rate: 21.587	Min: 21.419	Max: 21.745	2021 February
17	Wednesday-17 Feb 2021	21.5480	21.3570	21.7220	21.5395	59,021.78 Kč		58,521.70 Kč	59,521.86 Kč	Rate: 21.548	Min: 21.357	Max: 21.722	2021 February
FEBpq3

02-USDtoCZKHistory-Feb.xlsx
	A	B	C	D
1	Date	Rate	Minimum Rate	Maximum Rate
2	Thursday-04 Feb 2021	Rate: 21.536	Min: 21.497	Max: 21.576
3	Friday-05 Feb 2021	Rate: 21.538	Min: 21.497	Max: 21.578
4	Saturday-06 Feb 2021	Rate: 21.550	Min: 21.507	Max: 21.597
5	Sunday-07 Feb 2021	Rate: 21.547	Min: 21.496	Max: 21.598
6	Monday-08 Feb 2021	Rate: 21.593	Min: 21.533	Max: 21.647
7	Tuesday-09 Feb 2021	Rate: 21.578	Min: 21.512	Max: 21.641
8	Wednesday-10 Feb 2021	Rate: 21.539	Min: 21.467	Max: 21.611
9	Thursday-11 Feb 2021	Rate: 21.545	Min: 21.459	Max: 21.630
10	Friday-12 Feb 2021	Rate: 21.547	Min: 21.448	Max: 21.645
11	Saturday-13 Feb 2021	Rate: 21.560	Min: 21.446	Max: 21.670
12	Sunday-14 Feb 2021	Rate: 21.557	Min: 21.428	Max: 21.682
13	Monday-15 Feb 2021	Rate: 21.602	Min: 21.455	Max: 21.750
14	Tuesday-16 Feb 2021	Rate: 21.587	Min: 21.419	Max: 21.745
15	Wednesday-17 Feb 2021	Rate: 21.548	Min: 21.357	Max: 21.722
FEBpq2

02-USDtoCZKHistory-Feb.xlsx
	A	B	C	D
1	Date	Rate	Min Rate	Max Rate
2	02/04/2021	Rate: 21.536	Min: 21.497	Max: 21.576
3	02/05/2021	Rate: 21.538	Min: 21.497	Max: 21.578
4	02/06/2021	Rate: 21.550	Min: 21.507	Max: 21.597
5	02/07/2021	Rate: 21.547	Min: 21.496	Max: 21.598
6	02/08/2021	Rate: 21.593	Min: 21.533	Max: 21.647
7	02/09/2021	Rate: 21.578	Min: 21.512	Max: 21.641
8	02/10/2021	Rate: 21.539	Min: 21.467	Max: 21.611
9	02/11/2021	Rate: 21.545	Min: 21.459	Max: 21.630
10	02/12/2021	Rate: 21.547	Min: 21.448	Max: 21.645
11	02/13/2021	Rate: 21.560	Min: 21.446	Max: 21.670
12	02/14/2021	Rate: 21.557	Min: 21.428	Max: 21.682
13	02/15/2021	Rate: 21.602	Min: 21.455	Max: 21.750
14	02/16/2021	Rate: 21.587	Min: 21.419	Max: 21.745
15	02/17/2021	Rate: 21.548	Min: 21.357	Max: 21.722
FEBpq

 

[MrDB4Excel]

Figured out how to do this by myself. A bit different than my original and subsequent redo requests; however, actually turning out better than I expected.
Following then is the XL2BB view of my process that hopefully may benefit others.

USDtoCZKMonthlyHistory.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
2	Date	Average Rate	Minimum Rate	Maximum Rate	MIN & MAX Average	CZK Per Min/Max Average Rate		CZK Per Min Rate	CZK Per Max Rate	Rate	Minimum Rate	Maximum Rate
3	Thursday-18 Feb 2021	21.5390	21.3190	21.7620	21.5405	59,024.52 Kč		58,417.58 Kč	59,631.47 Kč	Rate: 21.539	Min: 21.319	Max: 21.762	2021 February
4
5	Thursday-18 Feb 2021	21.5390	21.3190	21.7620	21.5405	59,024.52 Kč		58,417.58 Kč	59,631.47 Kč	Rate: 21.539	Min: 21.319	Max: 21.762	2021 February
6
7	Thursday-04 Feb 2021	March
8	FEB	FEB
9
10		January	JAN	Hist	FEBHist			Formula breakdown:
11		February	FEB	pq3	FEBpq3			=XLOOKUP (lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])
12		March	MAR	pq2	FEBpq2			where:
13		April	APR	pq	FEBpq				lookup_value – the value you want to search;
14		May	MAY						lookup_array – the range or array where you want to search the value;
15		June	JUN						return_array – the range or array from which you want the result;
16		July	JUL						[if_not_found] – the value you want to display if there are no results found;
17		August	AUG		HelpSht lookup_value	HelpSht A4			[match_mode]
18		September	SEP		FEBpq3 lookup_array	FirstStep = A15:D15			0 – Exact Match (if no result found, then error)
19		October	OCT		FEBpq2 return_array	Current = A17:M17			1 – Exact or next smaller (if no result found, then the next smaller value will be displayed)
20		November	NOV						2 – Exact or next larger (if no result found, then the next larger value will be displayed)
21		December	DEC						3 – Wildcards
22									[search_mode]
23	Narrative of the Order of the Query & Subsequent Sheet Update Process								1 – to search from first
24	Step 1	First check to be sure FEBHist Sheet is updated to correct date before Query is run.							-1 – to search from last
25	Step 2	Check If FEBHist needs updated, do so before Query is run, this should be a daily activity.							2 – binary search ascending
26	Step 3	Next Run the Query.							-2 – binary search descending
27	Step 4	Copy the result from Row 7, this Sheet, to the next available blank row in FEBHist
28
29	Narrative of the Change of the Month From Previous to Next
30	Step 1	Before renaming worksheets copy FEBHist to USDtoCZK2021History.xlsx
31	Step 2	Select KUTOOLS PLUS, then the Worksheet dropdown
32	Step 3	In the Worksheet dropdown select Rename Worsheets…
33	Step 4	Select the 4 sheets indicated by the first 3 CAP letters of the month.
34	Step 5	Using the "From specific range" selection then point to the cell in column"C" containing the month needed.
HelpSht