Reputation: 6698
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
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
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.
Upvotes: 0