data tables

S

Suzi

I have a data table with column headers (U - Z) and row headers (A - E), I
would like to enter the two headers, e.g. V and E and find the number that
corresponds to those cell references within the table. Can anyone tell me
what I should be using in Excel to do this ? I am using Office 2003

Thanks
 
D

daniels012

I am not sure I understand your question, but let me take a stab at it.

For example:

A B C D E
25 16 44 36 28
U 14 21 18 52 6
V 7 33 25 18 21
W 19 37 26 88 16


If this is what you are describing, then use a Index function.

=INDEX(Range of cells,Cell you want to enter V, Cell you want to ente
E)
=INDEX(O10:AM89,Q8,R8)

Hope this helps!
Michae
 
S

Suzi

Thank you, I'll check Index's this evening. I'd have used Microsoft Help but
it is only useful if you know what you're looking for!
 
Top