Hello All,
I've been digging through the threads and cannot quite seem to find exactly what I am looking for. I have a 5 tab inventory system. Each tab contains vendors, items, on hand counts, and order qty (although, these pieces of information are not necessarily in the same columns in each tab). I want to create a 7th tab that will populate and order sheet. I want this sheet to search all 5 tabs for vendor X, determine if order qty is >0, and return item name. I am assuming that vendor x will have more than one item that needs to be ordered so I need this formula to populate and entire table as follows
Vendor X
<tbody>
</tbody>
Once I have the equation that will populate the item numbers based on Vendor x and order quantity >0 I should be able to handle the VLOOKUP equation that will return the Order qty based on Item #.
Thanks in advance for the help
I've been digging through the threads and cannot quite seem to find exactly what I am looking for. I have a 5 tab inventory system. Each tab contains vendors, items, on hand counts, and order qty (although, these pieces of information are not necessarily in the same columns in each tab). I want to create a 7th tab that will populate and order sheet. I want this sheet to search all 5 tabs for vendor X, determine if order qty is >0, and return item name. I am assuming that vendor x will have more than one item that needs to be ordered so I need this formula to populate and entire table as follows
Vendor X
Item | Order |
#1 | 1 |
#2 | 3 |
#3 | 1 |
#4 | 6 |
<tbody>
</tbody>
Once I have the equation that will populate the item numbers based on Vendor x and order quantity >0 I should be able to handle the VLOOKUP equation that will return the Order qty based on Item #.
Thanks in advance for the help