Creating a variable print list

  • Thread starter Thread starter SRK
  • Start date Start date
S

SRK

I have a list of 40 apartment names and want to print each name on 200 to 300
individual labels. My variable print software requires these in a continuous
list in one column: i.e. Name A, 300 times; Name B 200 times; Name C 250
times and so on. Is there an easier way than copying and pasting 40 names
into a column. I'm looking for a formula to do this.
 
formula is cell D1 is
=VLOOKUP(row(),A:C,3,1)
for the first 250 rows it gives nameone, then it gives nametwo, namethree
etc as you extend it down

Col A B C D
1 F-row T-row Name nameone
2 0 250 nameone nameone
3 251 351 nametwo nameone
4 501 600 namethree nameone
nameone
nameone
nameone
nameone
nameone
nameone
nameone
nameone
nameone
nameone
nameone
 
Back
Top