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.
|