Formula Recommedations

[EWRUCK]

Hi, I'm trying to get addresses to pull into monthly sheets from based on if a contract date is in the raw data and counted. Maybe I need more to do this. I have the raw data pulled in one tab, a tab with the data summed and compiling for other reasons and then I have monthly tabs. On the monthly tab I'm trying to get the addresses to pull from the data summed if there is a number in the executed contract summed but I feel like I'm going in circles. Because then I need the address from the raw data tab. I was thinking multiple Xlookups but I have not been successful and I feel like I'm missing something.

Is there a better way to approach this?

The top image is the spot where I want to pull in the address. The date is the start of the week.
The second image is the raw data on another tab. The address is broke out by date created then there is blank cells if nothing is in the appointment date or executed contract date.
Final image is of the 3rd tab where the raw data is summed by the dates in the columns. No address is associated in this tab.

If you have any thoughts on how I can better approach this to pull in the address, I'm all ears. I've been spinning my wheels and am striking out.

 

[PeteWright]

Hi @EWRUCK

Unfortunately I don't get what this is all about, so maybe you could describe it in other words?
Besides that, could you give a couple of examples of the resulting table (like input data and desired output) so I will get a better picture.

 

[EWRUCK]

Hi @EWRUCK

Unfortunately I don't get what this is all about, so maybe you could describe it in other words?
Besides that, could you give a couple of examples of the resulting table (like input data and desired output) so I will get a better picture.

Hi, thanks for asking for different wording. I have tried to do that below:

The second snip has a list of addresses and dates created. It also has dates for executed contact. I would like to have those addresses pull into the 1st snip as you see in that one, there is an address there under the week of 2/26. There could be more then one address for the same date. Then I’d like it to go to the next row.

The top snip has columns for each week of the month. It is also has the numeric week number listed.

I also have a 3rd snip of a table where the addresses are counted by date and header. So the executed contract date would have a number there. Not sure if that data is pertinent to this formulas needs.


Another example would be if there is data in that 2nd snip, column I, dated Feb 6th. Another address on that image would pull into that address into column E of the first snip and etc.

 

[EWRUCK]

I am adding in the 2xlbb since I have finally got that on my laptop and firugred out how to use it.

2025 True Neighbor KPI Dashboard Workup.xlsm
	A						G	H	I			L	M
1	Deal - Title						Deal - Deal created	Deal - Appointment Date	Deal - Executed contract date			Deal - Expected close date	Deal - Deal closed on
34	3612 Crosby Pl, Minneapolis, MN 55406						2/28/2025	3/4/2025
35	619 7th St S, Sartell, MN 56377						2/28/2025
36	28530 Coyote Ct, Red Wing Minnesota						2/28/2025						2/28/2025
37	14459 Vale St Nw, Andover Minnesota						2/27/2025	3/3/2025				5/28/2025
38	248 Ivy Ave W, St Paul Minnesota						2/26/2025	3/3/2025
39	10 115th Ave NE Blaine, MN 55434						2/26/2025						2/26/2025
40	1389 Rolling Hills Dr, Maplewood, MN 55119						2/26/2025						2/26/2025
Deal List Modified

2025 True Neighbor KPI Dashboard Workup.xlsm
	C	D	E	F	G	H	I	J	K
1
2					FEB	2/5/2025	2/12/2025	2/19/2025	2/26/2025
3			GOAL	TOTAL	RESULT	6	7	8	9
15
16	Executed Contracts (Projected/Closed)		ADDRESS			0	0	0	1
17	GOAL	7	6438 Riverdale Dr NW, Ramsey, MN 55303						1
Monthy KPI FEB

Cell Formulas
Range	Formula
H2:K2	H2	=XLOOKUP(H3,LISTTBL[Week '#],_53_Weeks)
H3	H3	='Monthy KPI JAN'!L3+1
I3:K3	I3	=H3+1
H16:K16	H16	=COUNT(H17:H21)
D17	D17	=E6
E17	E17	='Deal List Modified'!A223

Named Ranges
Name	Refers To	Cells
_53_Weeks	=Lists!$A$2:$A$406	H2:K2