Reputation: 53

Excel use of indirect

I am trying to reference another worksheet but can not get the indirect to work.

=INDIRECT(ADDRESS((MATCH(AD10,A1:A160,0))+ROW(Page!A1)-1,COLUMN(Page!A1),4))

It is only returning the search result for the page not for the page requested.

It needs to return the data in the cell not the location.

What is wrong?

Upvotes: 1

Answers (2)

Reputation: 53

=OFFSET(INDEX(Page!A1:A160,MATCH(AD10,Page!A1:A160,0)), AE10+1, 1)

This allowed me to move the row automatically and shift the column to gather that rows information....Thanks for the help.

Upvotes: 1

Reputation: 152660

How about this:

=INDEX(Page!A:A,MATCH(AD10,A1:A160,0)+ROW(1:1)-1)

Upvotes: 1