return value in table - multiple criteria

[lukeg23]

i am trying to return the value from a table based on two criteria. attached is sample workbook with two worksheets (summary and detail)

I would like to return the values from column "B Total" and "A Total" into my summary sheet. (ie. for B total in detail tab, row 24 should return $375.10 on row 11 under column F in summary tab)


I have sorted out the income line, need some help figuring the expense side of things

I should mention, I've tried a number of formulas (vlookup, xlookup, index x match) to no avail - hence the posting here.

thanks in advance, much appreciated!

[lukeg23]

not sure where to begin with vba after no luck on formulas

[maras_mak]

Test with worksheet formulas.
Worksheet 'summary'
"A Total" 'C9'

Please Login or Register  to view this content.

"B Total" 'F9'

Please Login or Register  to view this content.

[lukeg23]

Thanks Maras - is there a way to change this so that it is keying off of the descriptions instead of relative position? When I run this report, it will have a different number of columns and rows that I would like to pull from, rather than the same table each time.

[maras_mak]

Maybe it'll be okay now.
With a helper column - yellow (can be hidden).
The first words of 'Expenses' in both worksheets must be the same, these are keywords for the formulas to work well (no numbers at the beginning).