offset reference

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shashidhar - 23 Mar 2008 17:47 GMT

hi all

i have aproblem in giving offset reference

I J
3    500    600
4 1.2    0    0
5 1.6    1    0

I, J are column and 3,4,5, are row

500 and 600 are two options ( selected by togggle button)
1.2 and 1.6 are other two options ( selected by togggle button)

I have 4 seperate tables for 500-1.2 , 500-1.6, 600-1.2,600-1.6.

i have written an offset function concerened to 4 data in same sheet.
table ref
500-1.2 b9
500-1.6 h9
600-1.2 b17
600-1.6 h17

i want to reference (in offset) to change in accordance to value 1 in
the above table.
i.e in this case i want the refrence to be h9
where as if it is 600-1.2 refrence be b17

please help me

Reply to this Message

Jim Cone - 23 Mar 2008 22:33 GMT

I do not understand what you want to do.
Can you restate your problem and give an example of the offset formula
that you tried?

Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"shashidhar"
<rshashidhara@gmail.com>
wrote in message
hi all
i have a problem in giving offset reference

I J
3 500 600
4 1.2 0 0
5 1.6 1 0

I, J are column and 3,4,5, are row

500 and 600 are two options ( selected by togggle button)
1.2 and 1.6 are other two options ( selected by togggle button)

I have 4 seperate tables for 500-1.2 , 500-1.6, 600-1.2,600-1.6.

i have written an offset function concerened to 4 data in same sheet.
table ref
500-1.2 b9
500-1.6 h9
600-1.2 b17
600-1.6 h17

i want to reference (in offset) to change in accordance to value 1 in
the above table.
i.e in this case i want the refrence to be h9
where as if it is 600-1.2 refrence be b17

please help me

Reply to this Message