software

Hi All

I'm new to Excel and would like to know if it's possible to do the
following:

Define a table(2 dimensional array) of fixed data like this:

Tom Dick Harry

Alpha 10 7 5

Bravo 6 27 4

Charlie 17 22 8I'd then like to be able to reference each element in the array using
the row and column identifiers as indexes, so (Alpha, Harry) would
return 5, (Charlie,Harry) would return 8 and so on.

Tia
RHSay you have Alpha in F1, Harry in G1 and your data (including headers) in
A14
Enter formula:
=INDEX(B24,EQUIV(F1,A2:A4,0),EQUIV(G1,B11,0))

HTH
--
AP

quot;RedHookquot; gt; a écrit dans le message de news:
...
gt; Hi All
gt;
gt; I'm new to Excel and would like to know if it's possible to do the
gt; following:
gt;
gt; Define a table(2 dimensional array) of fixed data like this:
gt;
gt; Tom Dick Harry
gt;
gt; Alpha 10 7 5
gt;
gt; Bravo 6 27 4
gt;
gt; Charlie 17 22 8
gt;
gt;
gt; I'd then like to be able to reference each element in the array using
gt; the row and column identifiers as indexes, so (Alpha, Harry) would
gt; return 5, (Charlie,Harry) would return 8 and so on.
gt;
gt; Tia
gt; RH
gt;
Thanks Ardus - works great, although I had to use MATCH instead of
EQUIV for some reason.The reason is I'm a bloody frenchman, and forgot to translate the formula!

Cheers,
--
AP

quot;RedHookquot; gt; a écrit dans le message de news:
...
gt; Thanks Ardus - works great, although I had to use MATCH instead of
gt; EQUIV for some reason.
gt;
With your present configuration, you might try the quot;intersection operatorquot;,
which is a lt;Spacegt;.

=Bravo Dick
OR
=Dick Bravo
Will return 27

AS well as
=Alpha Harry
Will return 5

And
=Tom Charlie
Will return 17--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

quot;RedHookquot; gt; wrote in message oups.com...
Thanks Ardus - works great, although I had to use MATCH instead of
EQUIV for some reason.