Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text Lookup on MUltiple Sheets
OK, here is what I am trying to do. I have one worksheet for
inventory that I would like to connect to about 20 production worksheets. The inventory worksheet contains all 10 of my different types of inventory (wheat, barley, Corn, soy, oats etc.) Each production worksheet represents a field that can grow any of the crops in my inventory. Each production worksheet has a cell at the bottom that says what crop was grown on that field and my total yield from the field. So what I want to do is use the lookup function on each of the crops in my inventory to look at that specific cell on each of the identical worksheets, find the ones that match, return their values for total yield to the inventory sheet and and have them summed in a cell. Thanks for any help you can provide. Ihope this is in the right place as I am very new to this Usenet thing |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup across multiple columns within multiple sheets | Excel Discussion (Misc queries) | |||
Lookup using multiple sheets and multiple criteria, sorry if 2 pos | Excel Worksheet Functions | |||
Lookup using multiple sheets and multiple criteria | Excel Discussion (Misc queries) | |||
Sum values in multiple sheets using Lookup to find a text match | Excel Worksheet Functions | |||
Lookup multiple values on multiple sheets | Excel Programming |