List items based on quantity

Hi all,

Wondered if someone would be able to advise on the following.
I have a list of items which will be used for an order or kitting sheet.
What I want to do is pull across the quantity and description from the item list to the kitting sheet but only if the quantity value is greater than 0 (1 and above).

I have had a play around with IFERROR, but I just can't seem to crack it, and admittedly this is probably a little out of my league!

If anyone could advise I would be very grateful!

Sorry for some reason I can't attach the file but link to drop box here:
https://www.dropbox.com/s/tg6ns5efms...heet.xlsx?dl=0

Thanks in advance,

Andy

The following formulas should do what you want. To populate the Item Descriptions use the array entered formula*:

Formula:

Please Login or Register  to view this content.

To populate the Qty's use the formula:

Formula:

Please Login or Register  to view this content.

*Array entered formulas are activated by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Note: Array entered formulas won't work in merged cells (at least in v.2010), therefore in the attached copy of the file I used the 'Center across selection' from the Home tab > Number pane > Alignment tab.
Let us know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.

This modification to the array entered formula* in C12 and down (Kitting sheet, file attached to post #2) will index based on the absolute value of the quantities in the Items sheet:

Formula:

Please Login or Register  to view this content.

*See post #2.
Let us know if you have any questions.

Pretty sure that has to do with the formatting of the cells in column B. Change the format from custom ( 0;;;@ ) to General.
Let us know if you have any questions.