S
Steved
Hello from Steved
I have an index in Columns which has a Label the cell
below has a Label and below that a Constant. The index is
C4:AT125 In A1 and A2 I type the labels I am looking for
once found the approperate cells, which below is the cell
with the constant, which the formula will put the constant
in A3. As an example A1 found the first label in J17, A2
found the second label in J18 and the Constant therefore
is in J19. The formula in A3 puts the Constant from J18
into A3.
=INDEX($C$4:$AT$125,MATCH($A$1,$C$4:$AT$125,0), MATCH
($A$2,$C$4:$AT$125,0)) This gives #N/A What am I doing
wrong.
Thankyou.
I have an index in Columns which has a Label the cell
below has a Label and below that a Constant. The index is
C4:AT125 In A1 and A2 I type the labels I am looking for
once found the approperate cells, which below is the cell
with the constant, which the formula will put the constant
in A3. As an example A1 found the first label in J17, A2
found the second label in J18 and the Constant therefore
is in J19. The formula in A3 puts the Constant from J18
into A3.
=INDEX($C$4:$AT$125,MATCH($A$1,$C$4:$AT$125,0), MATCH
($A$2,$C$4:$AT$125,0)) This gives #N/A What am I doing
wrong.
Thankyou.