Try this:

=INDEX(Info!A1:H101,LOOKUP(2,1/(Info!F1:F101=B15),ROW(Info!F1:F101)),MATCH("Total ",Info!A1:H1,0))

--
Biff
Microsoft Excel MVP


"Don Murray" wrote in message
...
The first instance I am looking for is in column F, and they are never
together, but the cells are not always consistent. The info may be in row
22
and 33 one time and in row 18 and 20 the next, but there is always 2
instances.

"T. Valko" wrote:

Is there a way to modify thise formula to skip the first occurence

The first instance in which axis? Is there more than 2 instances? Is the
table sorted so that all instances are grouped together?

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