Is it possible to use XLOOKUP lookup and return value that are not on the same row?
Table 1 is the unstructured dataset that I'm trying use to look up from Table 2.
In Table 1 colA value ="1" is the Parent, and "2" is the Child and the number of rows are dynamic. And, the parent row containing the address.
example 1 Lookup Value Table2.A3 Lookup Array Table1.colB Return Array Table1.C3 & D3
example 2 Lookup Value Table2.A4 Lookup Array Table1.colB Return Array Table1.C5 & D5
example 3 Lookup Value Table2.A5 Lookup Array Table1.colB Return Array Table1.C5 & D5
Table 1 is the unstructured dataset that I'm trying use to look up from Table 2.
In Table 1 colA value ="1" is the Parent, and "2" is the Child and the number of rows are dynamic. And, the parent row containing the address.
example 1 Lookup Value Table2.A3 Lookup Array Table1.colB Return Array Table1.C3 & D3
example 2 Lookup Value Table2.A4 Lookup Array Table1.colB Return Array Table1.C5 & D5
example 3 Lookup Value Table2.A5 Lookup Array Table1.colB Return Array Table1.C5 & D5