Table Reference Syntax

	B	C	D	E	F	G	H
1
2
3
4
5	name	label	color	w	h	px
6	name1	label1	red	10	5	50
7	name2	label2	yellow	20	10	200
8	name3	label3	green	30	15	450
9	name4	label4	cyan	40	20	800
10	name5	label5	blue	50	25	1250
11	name6	label6	magenta	60	30	1800
12
13
14	Find
15	name2
16
17	Result						Formula in B18
18	yellow	20	10				= XLOOKUP($B$15, tableTest[name], tableTest[[color]:[h]])
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100