Composite list

I'm trying to make a list of 15 names (List A) based on two other lists (B and C). List B has between 0 and 15 names, List C has at least 15. List A should contain all the names in List B, using List C (top to bottom) to fill in the remaining open spots until there are 15 names in List A.

I'm stumped - thanks in advance for your help!

if you don't want to use VBA
then
add a column before B & C - so now you have column B & Column C (List B) + Column D & Column E(List C)
Cell B1 (beside the top name in Column B) =1
Cell B2

Please Login or Register  to view this content.

this should number column B 1-15
Cell D1

Please Login or Register  to view this content.

Cell D2

Please Login or Register  to view this content.

That should continue your numbering
Then you can use vlookups to fill List A =if(countif(B1:B15,1)=1,vlookup(B1:B15,1,2,False),vlookup(D1:D15,1,2,False))
etc...

Here is an example worksheet

That works great for how I explained it, but I didn't quite explain it well enough. =)

I'm actually planning to have quite a few partial lists (like List B) that I want to turn into full lists (like List A), all being filled in with a single "leftovers" list (like List C). I'd like to do it without getting into macros, but I'm hoping there's a simpler way than giving List C a numbering column for each of the first sets of lists.

... anybody?

Another option to try
List B assumed in B2:B16
List C in C2:C16
To produce List A, as per specs
Put this in A2:
=IF(ROWS($1:1)>COUNTA($B$2:$B$16),INDEX($C$2:$C$16,ROWS($1:1)-COUNTA($B$2:$B2)),B2)
Copy down to A16