View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Paul Lautman
 
Posts: n/a
Default 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.