Return multiple rows - should I be using VLOOKUP?

With TABLE1, my data is laid out as follows. One thing to keep in mind is that sometimes, A1 and A2 may be merged (which has caused me headaches with formulas).

TABLE1 (on worksheet1)

	A	B
1	TEST1	Completed sample1
2		Finish work papers
3	PROJECT4	Submit RFP
4	PROJECT7	Submit RFP
5	TEST8	Gather sample data
6		Submit data to supervisor

I then would like to have another table on another worksheet that looks like this. You can see how it gets everything from TABLE1 column B related to TEST1. The reason for the blank row is that there may at times be more than just two items in column B on TABLE1. I would still want to be able to copy the formula into A4, but if there is no associated data, it would be blank.

TABLE2 (on worksheet2)

	A
1	TEST1
2	Completed sample 1
3	Finish work papers
4

Is the best way to achieve this using VLOOKUP? I can figure out how to do it with a formula similar to "=VLOOKUP($A$1,TABLE1,2,FALSE)" for TABLE2 cell A2, but just copying it to A3 produces the same data in A2 (Completed sample 1) instead of the data I really want. I would like to use the same formula in A2, A3, and A4 without having to change it (but I could if that's the only way).

It would help if you attached a sample Excel workbook. The yellow banner at the top of the screen gives details of how to do this.

I think it would be better to use a helper column on Table1 which helps to identify those records which have a blank in column A, and then you can use INDEX/MATCH instead of VLOOKUP in Table2 to get the full list of records (in conjunction with the ROWS function).

Hope this helps.

Pete

Think I got the formula working after your suggestion. Uploaded a sample. If you look on worksheet A4, cells B15:B17 all have a index. Works on A4. On worksheet PC2, it works fine in B15 and B16, but B17 should have something in it since PC2 has 3 rows on 'Master Matrix' worksheet. Can't figure it out.

I'm just about to have a break now for several hours. I'll check back later to see if anyone else has responded.

Pete