Hi all, just wondering if anybody can help me with a lookup function
problem...
I have an excel matrix with 123 rows (each numbered 1-123) and 133
columns (all named col1, col2...col133) is there anyway of "looking up"
the value in the cell where the row number is 32 and the column is
called col7?
I was reading about the hlookup function and from that I would have
thought that the following would have worked:

=HLOOKUP("col7", C1:EE124, 32)

Am I doing something wrong?

Thanks in advance

Hi Rob

Use Index function

Thanks
Xcelion


"robdken" wrote:

Hi all, just wondering if anybody can help me with a lookup function
problem...
I have an excel matrix with 123 rows (each numbered 1-123) and 133
columns (all named col1, col2...col133) is there anyway of "looking up"
the value in the cell where the row number is 32 and the column is
called col7?
I was reading about the hlookup function and from that I would have
thought that the following would have worked:

=HLOOKUP("col7", C1:EE124, 32)

Am I doing something wrong?

Thanks in advance