M
mbailey256
OK I'll start off with asking if there is a simply way to submit an X
and Y values to an array and have it return the Z value, because I
haven't been able to find it.
I was able to create the following formula that worked fine for one
array, the only problem is that we have 2 different arrays for the
different production groups, so I need to be able to test a third value
to determine which array to use.
=INDEX(U4:AX9,MATCH(0.06,U4:U9,1),MATCH(52.13,V3:AN3,1))
When I attempted to create a function based on the above formula, it
fails on the Gauge and Width variables.
HR_Array =
Evaluate("=INDEX(Tables!$U$4:$AX$9,MATCH(gauge,Tables!$U$4:$U$9,1),MATCH(width,Tables!$V$3:$AN$3,1))")
Would there be a way to simply pass the cell position rather than the
values to the above formula? I'm open to suggestions as to how to make
the above work or if someone has a best practice that would work all
the better.
Thanks,
Mike Bailey
Decatur, AL
and Y values to an array and have it return the Z value, because I
haven't been able to find it.
I was able to create the following formula that worked fine for one
array, the only problem is that we have 2 different arrays for the
different production groups, so I need to be able to test a third value
to determine which array to use.
=INDEX(U4:AX9,MATCH(0.06,U4:U9,1),MATCH(52.13,V3:AN3,1))
When I attempted to create a function based on the above formula, it
fails on the Gauge and Width variables.
HR_Array =
Evaluate("=INDEX(Tables!$U$4:$AX$9,MATCH(gauge,Tables!$U$4:$U$9,1),MATCH(width,Tables!$V$3:$AN$3,1))")
Would there be a way to simply pass the cell position rather than the
values to the above formula? I'm open to suggestions as to how to make
the above work or if someone has a best practice that would work all
the better.
Thanks,
Mike Bailey
Decatur, AL