Thread: How can I skip first the first occurence in an index search?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Murray Don Murray is offline
external usenet poster
  
Posts: 1
Default How can I skip first the first occurence in an index search?
During an index search my first occurence is always blank.
Is there a way to modify thise formula to skip the first occurence and check
for the second as the second occurence always contain the figure. Currently
there is no way to remove the first occurence.
=INDEX(Info!$A$1:$H$101, MATCH(B15,Info!$F$1:$F$101,),
MATCH("Total",Info!$A$1:$H$1,))
Reply With QuoteReply With Quote