Thanks that seemed to have solved the problem

"Max" wrote:

Think you adapted it wrong ..
.. Here is the formula I used
=OFFSET('data'!$A$1, MATCH(Sheet1!B15, 'data'!$1:$1, 0)-1, MATCH(Sheet1!B5, 'data'!A:A,0)-1)

Try this adaptation instead:
=OFFSET(data!$A$1,MATCH(Sheet1!B5,data!A:A,0)-1,MATCH(Sheet1!B15,data!$1:$1,0)-1)

where Sheet1's B5 houses the row header numbers: 22, 33, 44...
and Sheet1's B15 houses the col header letters: Z, Y, X ...
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"skier464" wrote:
Didn't seem to work, it returned a value but not the right value
. Maybe I had an error in the formula? Here is the formula I used
=OFFSET('data'!$A$1, MATCH(Sheet1!B15, 'data'!$1:$1, 0)-1, MATCH(Sheet1!B5,
'data'!A:A,0)-1)


'data' being my main spread sheet, Sheet1 being the secondary sheet. B15
being the column variable, and B5 being the row variable. Also I get ref when
I change the row variable much above 100.