Beginner Array Question

[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

 

[Bob Phillips]

=INDEX(U4:AX9,MATCH(1,(U4:U9=0.06)*(V3:AN3=52.13),0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

is the way I would do it

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)