CODEWITHSUNDEEP
excelnumbersrow
Majlo
Majlo

Reputation: 13

Excel dynamic row

Hi i am using these formulas to extract some data from one sheet to another. 

='[test.xlsx]Some Fantastic Sheet Name'!A1

='[test.xlsx]Some Fantastic Sheet Name'!B1

='[test.xlsx]Some Fantastic Sheet Name'!C1

I got number (1) in cell for example D1. Is it posible to change row numbers in formulas by changing the number in cell D1? ...So when D1 is 2 it will look like this:

='[test.xlsx]Some Fantastic Sheet Name'!A2

='[test.xlsx]Some Fantastic Sheet Name'!B2

='[test.xlsx]Some Fantastic Sheet Name'!C2

Upvotes: 1

Views: 29

Answers (1)

Scott Craner
Scott Craner

Reputation: 152465

Yes,

This is a non Volatile formula(INDIRECT and OFFSET are Volatile)

=INDEX('[test.xlsx]Some Fantastic Sheet Name'!A:A,D1)

Upvotes: 2

Related Questions