Posted to microsoft.public.excel.worksheet.functions
|
|
How can I skip first the first occurence in an index search?
Don,
Try
=INDEX(Info!$A$1:$H$101,(MATCH(B15,OFFSET(Info!$F$ 1:$F$101,MATCH(B15,$F$1:$F$101,FALSE),0)))+MATCH(B 15,$F$1:$F$101,FALSE),MATCH("Total",Info!$A$1:$H$1 ,))
HTH,
Bernie
MS Excel MVP
"Don Murray" <Don wrote in message
...
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,))
|