Hello and thanks in advance,
I am trying to use a formula to generate the wording of a named range then in another cell, return the intersecting point of two ranges by using that generated named range and another pre-determined named range.
Example:
Created named ranges on sheet 2:
Columns: Range A, Range B, Range C...
Rows: Range 1, Range 2, Range 3...
Intersecting data point of Range C and Range 2 is the number 100
On sheet 1 in cell A1, I input the number I want. For this example, let's say "2". In cell C1, I use a concatenate formula to generate the visual look of the named range "Range 2". =CONCATENATE("Range ",A1). In cell E1 I would like to use my generated name range, Range 2, and find the intersecting data point at Range C (100). =C1 Range C.
Ultimately, I want the formula in cell E1 to read as =Range 2 Range C to generate the data point 100. The problem is the first range may vary between 100's of numbers and different combinations, therefore I am not able to hard code it.
Any help is appreciated and I thank you in advance.
I am trying to use a formula to generate the wording of a named range then in another cell, return the intersecting point of two ranges by using that generated named range and another pre-determined named range.
Example:
Created named ranges on sheet 2:
Columns: Range A, Range B, Range C...
Rows: Range 1, Range 2, Range 3...
Intersecting data point of Range C and Range 2 is the number 100
On sheet 1 in cell A1, I input the number I want. For this example, let's say "2". In cell C1, I use a concatenate formula to generate the visual look of the named range "Range 2". =CONCATENATE("Range ",A1). In cell E1 I would like to use my generated name range, Range 2, and find the intersecting data point at Range C (100). =C1 Range C.
Ultimately, I want the formula in cell E1 to read as =Range 2 Range C to generate the data point 100. The problem is the first range may vary between 100's of numbers and different combinations, therefore I am not able to hard code it.
Any help is appreciated and I thank you in advance.
