Thread: using OFFSET(INDEX(MATCH)))
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave F[_2_] Dave F[_2_] is offline
external usenet poster
  
Posts: 187
Default using OFFSET(INDEX(MATCH)))
I have the following formula:

=OFFSET(INDEX('Capital Summary'!F$25:F$28,MATCH(A4,'Capital Summary'!F
$25:F$28,0)),,1)

This works fine, however, when I remove the OFFSET(...) part and just
have

=INDEX('Capital Summary'!F$25:F$28,MATCH(A4,'Capital Summary'!F$25:F
$28,0))

the matched value is returned, not its cell address. How does OFFSET
pick up the cell address?

Reply With QuoteReply With Quote