CODEWITHSUNDEEP
excelexcel-formula
WhichDr
WhichDr

Reputation: 11

Simplify dragging an excel formula

I have a formula =$A$1... that I would like to change to =$A$2 as I drag it to the right or change to =$B$1 as I drag it down.

Is there a trick to do this? Is it possible?

Upvotes: 1

Views: 50

Answers (1)

teylyn
teylyn

Reputation: 35915

You can use a formula like this

=INDEX($A$1:$C$3,COLUMN(A1),ROW(A1))

enter image description here

Upvotes: 5

Related Questions