XLookup going "out of sync" because data missing from lookup array

[pincarrot 776]

Hi Everyone,
I try to "scatter" values from one data set to table with xlookup. In reality the target-table is very big. These are 2d coordinates I try to place, data itself comes from other program. As far as I have "all the values" in the source, it goes smooth. But then when there is a gap in source data, it goes out of sync and looks for the data from the wrong place. Is there a way to fix this, Im thinking my whole approach might be wrong. In fact I have so little idea about what Im doing that I cant even find answer from Google.

Thank you for any help.

 

[felixstraube]

Im guessing you have your data as a table.
Then how about this?:

Libro1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2
3	X	Y	Data	Name				-12,50	-12,25	-12,00	-11,75	-11,50	-11,25
4	-12,50	19,50	500				19,50	500	-	-	-	-	-
5	-12,25	19,25	300				19,25	-	300	-	-	-	-
6	-11,25	15,75	200				19,00	-	-	-	-	-	-
7							18,75	-	-	-	-	-	-
8							18,50	-	-	-	-	-	-
9							18,25	-	-	-	-	-	-
10							18,00	-	-	-	-	-	-
11							17,75	-	-	-	-	-	-
12							17,50	-	-	-	-	-	-
13							17,25	-	-	-	-	-	-
14							17,00	-	-	-	-	-	-
15							16,75	-	-	-	-	-	-
16							16,50	-	-	-	-	-	-
17							16,25	-	-	-	-	-	-
18							16,00	-	-	-	-	-	-
19							15,75	-	-	-	-	-	200
20							15,50	-	-	-	-	-	-
21							15,25	-	-	-	-	-	-
22							15,00	-	-	-	-	-	-
23							14,75	-	-	-	-	-	-
24							14,50	-	-	-	-	-	-
25							14,25	-	-	-	-	-	-
Hoja1

Cell Formulas
Range	Formula
H4:M25	H4	=IFERROR(FILTER(Table1[[Data]:[Data]],(Table1[[X]:[X]]=H$3)*(Table1[[Y]:[Y]]=$G4)),0)

 

[pincarrot 776]

Thank you! In your output it seems to solve the thing, but it does not work for me yet. I think I have to fix some references in order to get it working?