Plummer
Plummer

Reputation: 6698

Excel named range as index

I am using this formula:

=INDEX(Listings!$A$2:$X$4915,MATCH(H1,Listings!$B$2:$B$4915,0),14)

I want the Index array to be a named range, like so:

=INDEX(myRange1,MATCH(H1,myRange2,0),14)

When I try this, I get a #ref error. Ranges are set to same array as listed in the first formula.

Upvotes: 1

Views: 3072

Answers (2)

John Bustos
John Bustos

Reputation: 19574

... I just did exactly what you mentioned and it worked just fine... Did you define the names correctly??? If you try and navigate to that range, does it work??

Upvotes: 2

bonCodigo
bonCodigo

Reputation: 14361

Row_num, column_num, and area_num must point to a cell within reference; otherwise, INDEX returns the #REF! error value. If row_num and column_num are omitted, INDEX returns the area in reference specified by area_num.

reference site

Upvotes: 0

Related Questions