combining data from two sources

[M]

I have done something similar but am still unsure of how
to complete the formula. I have created a column that
identifies the rows in table one as either containing a
value or blank. I then created an if statement in my
desired table that says, If(M2="Value",Table1!a2,Table2!
$a$2) and pasted this all the way down. This pulls in all
of the values for the first table and the first value of
the second table, but I am not sure how to get the rest of
the rows from the second table into the sheet. Do you
follow?

-----Original Message-----
=CountA(Sheet1!A:A)

will tell you how many rows in Column A contain data.

Row()

will tell you want row your formula is in. So you can use an if statement
that compares the row with the formula to the count of the rows in the first
table. If less or equal to, look at the first table. If more, then look at
the second table.

--
Regards,
Tom Ogilvy




.

..