General wrote...
....
A1: GE
A2: (empty)
A3: Q104
A4: Q204
A5: Q304
A6: (empty)
A7: Ford
A8: Q104
A9: Q304
A10: (empty)
A11: (empty)
A12: AOL
....
Given a company name (GE, Ford, AOL, et...) and a quarter (Q104, Q204,
etc..), I need to be able to return the row number for that quarter for
that company.
....

If the list begins in A1 (so in row 1), and company name were entered
in a cell named COID and quarter in a cell named QTR, enter Q1, Q2, Q3
and Q4 in a single column range just below a blank cell (e.g., X2:X5
with X1 blank) and name that range - INCLUDING the blank cell - QP,
then try the array formula

=MATCH(QTR,OFFSET(A1:A100,MATCH(COID,A1:A100,0),0, MATCH(0,
COUNTIF(QP,LEFT(OFFSET(A1:A100,MATCH(COID,A1:A100, 0),0),2)),
0)-1,1),0)+MATCH(COID,A1:A100,0)