building formula using integers in different cells

[umbata]

Hi,

I'm using the following cell formula:

=INDEX('financial-milling'!$H$3630:$HR$3630,MATCH(AK$30,'financial-milling'!$H$5:$HR$5,))/1000

Does anyone know of a way to replace the reference to '3630' with an integer value referenced from a different cell? This would enable to change $H$3630 reference in formula by entering a new integer value in a different cell.

Thanks,

[etaf]

assuming the cell used is A1 and B1
=INDEX('financial-milling'!$H$3630:$HR$3630,MATCH(AK$30,'financial-milling'!$H$5:$HR$5,))/1000
then you should be able to use the indirect

which should be

=INDEX(indirect("'financial-milling'!"&A1&":"&B1),MATCH(AK$30,'financial-milling'!$H$5:$HR$5,))/1000

your missing part of the match after $HR$5, ???? ))

simplified
=INDEX(INDIRECT(A1&":"&B1),MATCH(A2,F1:F10,0))
see attached formula

see formula in A5
uses A1, B1 and A2

so if you change A2 - the result will change
also cell A1 and B1 shows the range

if all you want to change is the row number than

=INDEX(indirect("'financial-milling'!H"&A1&":HR"&B1),MATCH(AK$30,'financial-milling'!$H$5:$HR$5,))/1000
and just put the row numbers in A1 and B1

if the ROW is the same
then just use 1 cell - for example A1
=INDEX(indirect("'financial-milling'!H"&A1&":HR"&A1),MATCH(AK$30,'financial-milling'!$H$5:$HR$5,))/1000