Lawrence
07-17-2008, 03:49 PM
“Data Sheet” is compiled by looking at multiple sheets and extracting the necessary data.
In “Graph1”, the same data as in “Data Sheet” is rearranged in columns Q through AA, and then a VLookup is performed to get the output in the black box. Although it works, it seems very inefficient. What I am looking for is to bypass columns Q through AA and go straight to the output with something like this:
Cell F40: Look for May-08 (Cell F39) in “Data Sheet”, once you find it, look for Bolts (Cell C40) in “Data Sheet”, once you find it, look for Total (Cell 39) in “Data Sheet”, and return the appropriate value. Same formula for cells F41-F43.
For the prior months (Columns G-M), the same formula would be used or once it found the appropriate cell in “Data Sheet” to populate cell F40, the formula could “go up” 9 rows and return that value in Cell G40, and another 9 rows and return that value in cell H40, and so on.
In “Graph2” I’d like to do something similar to populate the table in B53:I76.
Is this possible or do I have to still manipulate the data?
In “Graph1”, the same data as in “Data Sheet” is rearranged in columns Q through AA, and then a VLookup is performed to get the output in the black box. Although it works, it seems very inefficient. What I am looking for is to bypass columns Q through AA and go straight to the output with something like this:
Cell F40: Look for May-08 (Cell F39) in “Data Sheet”, once you find it, look for Bolts (Cell C40) in “Data Sheet”, once you find it, look for Total (Cell 39) in “Data Sheet”, and return the appropriate value. Same formula for cells F41-F43.
For the prior months (Columns G-M), the same formula would be used or once it found the appropriate cell in “Data Sheet” to populate cell F40, the formula could “go up” 9 rows and return that value in Cell G40, and another 9 rows and return that value in cell H40, and so on.
In “Graph2” I’d like to do something similar to populate the table in B53:I76.
Is this possible or do I have to still manipulate the data?