I tried this with adding the info! in the proper places as the data is on a
seperate page but couldn't get it to work, any ideas?


"Bernie Deitrick" wrote:

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,))