not sure how to phrase this but I'll try to keep simple with an example below (sorry I couldn't figure out the table function). I have an "itemized" worksheets and a summary worksheet.
Sheet named "ITEMS01":
APPLES ORANGES BANANAZ
count1 6
count2 1
count3 2 4
sum 6 3 4
Summary Sheet:
ORANGES APPLES BANANAZ
ITEMS01 3 6 4
ITEMS02 # # #
etc. # # #
So far I'm able to use INDIRECT to make the reference find the item sheet name, also I can have it reference a specific cell in them. The problem comes in because, similar to example above, the columns are not always in the same order and the row where the sum is not always the same (it could be row 3 or row 553)
Is there some combination of this:
=INDIRECT("'"&A2&"'!B150")
and this:
=INDEX(B:B,MATCH(3E+100,B:B,1))
where instead of B:B it looks for column titled APPLES then returns the southernmost numerical value in that column?
Thanks in advance.
Bookmarks