Max - thank you again for your persistence.

1) Yes - you are correct - typo is as you have indicated (thanks).

2) Formulas for AK4, 5 and 6 are respectively as follows:
=IF('Sheet 2'!D20="2B",'Sheet 2'!H20,'Sheet 2'!G20)*(1+'Sheet 2'!$I$2);
=IF('Sheet 2'!D26="2B",'Sheet 2'!H26,'Sheet 2'!G26)*(1+'Sheet 2'!$I$2);
=IF('Sheet 2'!D50="2B",'Sheet 2'!H50,'Sheet 2'!G50)*(1+'Sheet 2'!$I$2).

3) Formulas for AM4, 5 and 6 respectively:
='Sheet 2'!I20;
='Sheet 2'!I26;
='Sheet 2'!I50.

4) Values returned in AM3, 4, 5 and 6 are respectively:
40.13;
29.75;
51.98;
32.94.

5) No - simply to be read from the formula - that is for the above insert
rows numbers in the initial forumla of 20, 36, 50 etc. (but no pattern to
this - needs to pull it out of the AM reference.

I hope this helps and is sufficient.

Kind regards,

Boyd







"Max" wrote:

Think some further clarification is needed:

I have the following formula in cell AK3 of Sheet 1:
=IF('Sheet 2'!D8="2B",'Sheet 2'!H8,('Sheet 2'!G8)*(1+'Sheet'!$I$2))

Is there a typo in the formula above: ... 'Sheet'!$I$2))
Should it be ... 'Sheet 2'!$I$2))
or do you really have a sheet named as : Sheet

Pl also paste the formulas you have in AK4, AK5, AK6
for better clarity as to the formula structure down in col AK

and a cell to the right, AM3, I have:
='Sheet 2'!I8

Pl paste the formulas you have in AM4, AM5, AM6
for clarity

What are the values returned in the cells AM3, AM4, AM5, AM6 ?

Is the row number to be used in col AK's formula to be read from the values
returned in col AM, or ??

If you'd like to, send me a copy of your file (may be easier to figure out
what the deuce is happening <g)

Send to either:

demechanik <atyahoo<dotcom
or
xdemechanik <atyahoo<dotcom

(both valid)

Will a macro do this instead?

Think we could probably try using INDIRECT to string something up first,
might suffice

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"BDB" wrote in message
...
Max - thank you kindly for your reply.

Yes, very close except that the only pattern to the offset is that it is
the
same Column but a different pattern to the selection of row numbers.

I am hoping for the row numbers in the formula to change to that in the
reference cell.

I have the following formula in cell AK3 of Sheet 1:
=IF('Sheet 2'!D8="2B",'Sheet 2'!H8,('Sheet 2'!G8)*(1+'Sheet'!$I$2))

and a cell to the right, AM3, I have:
='Sheet 2'!I8

I'd like the computer to take the row number referred to in the righthand
corresponding cell in the Column AM and replace the row number in the
above
formula for the rest of the cells in Column AK, so I don't have to
manually
insert them again [as I have previously done for the AM column]. There is
no
pattern to the selection of the rows other than through the reference cell
to
the right.

Will a macro do this instead?

I hope this makes more sense.

Regards,

Boyd