lookup function
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
|