can I pick start point in a range?
 

Hi, am trying to make an equation that varies the start point within a range.
Can I use a fixed cell to designate another non-fixed cell? thanks

such as: (for range: f10:M10)..

=IF(AND($A$3=4,$A$4=2),work g11:j11)

can I pick start point in a range?
 

nastech wrote:
Hi, am trying to make an equation that varies the start point within
a range. Can I use a fixed cell to designate another non-fixed cell?
thanks

such as: (for range: f10:M10)..

=IF(AND($A$3=4,$A$4=2),work g11:j11)

By equations I take it you mean formula.

Look at the INDEX and OFFSET functions.