Ok, sheet 1 lists 2000 products to reorder. I'd llike to put a check box next to each one so when it's checked sheet 2 will have a reorder list made. If I check item #'s 200, 300, and 800 I want only those items to show on sheet 2 cells A1 thru A3.
Which cell on the 'Reorder List' sheet is this formula in? Did you COPY the above formula from your sheet to your post on the board? What are the values in C1:C11 of the 'Products' sheet?ycul222 said:Yes, I think it's a start. I follow the first part but the second doesn't work. I get #REF!
=IF(ROW()-1>Products!$C$1,"",INDEX(Products!A:A,1+MATCH(ROW()-1,Products!C$2:C$11,0)))
suggestions?