Thread: lookup function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
robdken robdken is offline
external usenet poster
 
Posts: 1
Default 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