Lookup

[Ronnie S]

Help.

I have a rather large table and within that table I have one particular
column that has some calculated values and following that I have column
headers with values from 0.5 to 6.0 in increments of 0.5 e.g.

0.5 1.0 1.5 2.0 2.5 3.0 3.5 4.0 4.5 5.0
5.5 6.0
2.0
2.5
3.0
3.5 28
0.5
1.0
5.5
for every row I want to lookup a value in its related column, in the example
above row=3.5 column=3.5 lookup value = 28.

I would really appreciate it if someone could help me with this one
particular problem.

Thanks
Ronnie

 

[Mike]

Where did 28 come from?

 

[Ronnie S]

Thanks Thomas,

I researched it out and I will not only need to use an index but a MATCH in
the index too.
i.e.
index(tablearray,match(cellReference,tablearray,referenceType),match(columnN
ame,columnNum))
I am sorry to have been a bother.
Thanks again.
Ronnie