How to get the Account code from the formula refer the amount column

Question

Hi,&nbsp;I have 2 sheets in workbook. 1st sheet is Summary sheet and other one is details sheet. I have attached the sample sheet with required result in highlighted cells,&nbsp;1st sheet having the sample balance sheet where it summarizes the accounts amounts from the details sheet. i want the account number in 1st sheet against group of balance sheet accounts as per the amount total.&nbsp;Thank you in advance&nbsp;Tejas Shah&nbsp;

riny_van_eekelen · Answer

Tejas_shah&nbsp;Try this:=SUM(MMULT(TRANSPOSE(Details!$F$4:$F$14),--(Details!$B$4:$B$14=E4:J4)))&nbsp;Entered in D4 of the attached file and copied down.

tejas_shah · Answer

Thank you for the reply I want the accounts no which is highlighted in summary sheet.

riny_van_eekelen · Answer

Tejas_shah&nbsp;Sorry, but i don't understand.

tejas_shah · Answer

Riny_van_Eekelen&nbsp;&nbsp;&nbsp;I want the for PPE which are the accounts added to for the value. i.e. 1001 - 1008 which is highlighted.&nbsp;

riny_van_eekelen · Answer

Tejas_shah&nbsp;Still don't understand. I assumed you wanted a formula that calculated 1250 for PPE, based on the account numbers mentioned. Isn't that correct?

Forum Discussion

How to get the Account code from the formula refer the amount column