View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
RedHook
 
Posts: n/a
Default Define and Reference fixed data in a table

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