Thread
:
Define and Reference fixed data in a table
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Ardus Petus
Posts: n/a
Define and Reference fixed data in a table
Say you have Alpha in F1, Harry in G1 and your data (including headers) in
A1:D4
Enter formula:
=INDEX(B2:D4,EQUIV(F1,A2:A4,0),EQUIV(G1,B1:D1,0))
HTH
--
AP
"RedHook" a écrit dans le message de news:
...
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 8
I'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
RH
Reply With Quote