Thread: Index Match Match?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] hansjhamm@yahoo.com is offline
external usenet poster
  
Posts: 47
Default Index Match Match?
This one just seems to stump me!
What I have in the cell is:

=INDEX(Sheet1!C2:C1000,MATCH(D104,Sheet1!A2:A1000, 0),MATCH(Sheet3!E104,Sheet1!B2:B1000,0))

and it gives me the eternal #REF!

What am I JUST NOT GETTING?


Thanks

Hans

Reply With QuoteReply With Quote