Thread: Index return value REF#!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pilar Morales Pilar Morales is offline
external usenet poster
  
Posts: 8
Default Index return value REF#!
This formula returns REF#!

=1*(INDEX(x!$A$1:$AW$128,MATCH($A$27,x!$A$2:A500), MATCH(N7,x!$B$1:$AV$1)))

The values are correct in the evaluate formula box, Row:10, Col 2, but then
it breaks down.

I'e also tried
INDEX(x!$A$1:$AW$128,MATCH($A$27,x!$A$2:A500),MATC H(N7,x!$B$1:$AV$1))

I need the formula to return the value in that cell (in this case, B10)

What am I doing wrong?

Thank you!
Reply With QuoteReply With Quote