Sequential vlookup in Excel

Question

Hi there - I am trying to work out how to do a vlookup on a table based looking up two colums.

i.e. In the table below, I want to create a formula which return to a summary table the number for Q4'13 for USA Brand A, then USA Brand C, then Argentina Brand A, then Argentina Brand F.

Does anyone know if this is possible?

Thanks!

		Q1'13	Q2'13	Q3'13	Q4'13
USA	Brand A	8.2	8.3	8.5	8.6
USA	Brand B	7.6	7.3	7.3	7.0
USA	Brand C	7.3	7.1	7.1	7.0
USA	Brand D	8.4	8.3	8.5	8.6
Argentina	Brand A	8.2	8.1	8.2	8.2
Argentina	Brand B	7.6	7.4	7.6	7.6
Argentina	Brand F	7.3	7.4	7.3	7.3
Argentina	Brand E	8.4	8.3	8.4	8.4
Argentina	Brand D	7.3	7.3	7.0	8.8
Australia	Brand A	7.1	7.1	8.2	8.2
Australia	Brand F	8.8	8.8	7.6	7.6
Australia	Brand E	7.6	7.3	7.3	7.0
Australia	Brand D	7.3	7.1	7.1	7.3

Answer 1

Assuming you want like this as per my interpretation

Put following formula in H2 and drag it to I2 also. 

=IF(2*ROWS($1:1)>COUNTA($A:$A)-1,"",INDEX(A:A,2*ROWS($1:1)))

Put following in J2.

=IF(2*ROWS($1:1)>COUNTA($A:$A)-1,"",INDEX(F:F,2*ROWS($1:1)))

Drag down above formulas

Answer 2

Hope I have understood the question correctly

Screen shots show my data and a small table that can be extended as needed.

Not the use of helper column C which you could hide if that helps.

best wishes