can I pick start point in a range?

N

nastech

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)
 
P

Paul Lautman

nastech said:
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)
Click to expand...

By equations I take it you mean formula.

Look at the INDEX and OFFSET functions.
 
Top