Forum Discussion
How to get the Account code from the formula refer the amount column
Hi, 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, 1st sheet having the sa...
Thank you for the reply I want the accounts no which is highlighted in summary sheet.
Sorry, but i don't understand.
I want the for PPE which are the accounts added to for the value. i.e. 1001 - 1008 which is highlighted.
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?
Riny_van_Eekelen
No i want the account code which is calculated the amount 1250.
so next to ppe cell i have formula which is getting the amount from detail sheet. Ie. =SUM(Details!F4:F7,Details!F10:F11)
So i Want the corresponding account code which is in Column B in detail sheet.
So i gave the example in summry sheet which accounts total summing up to PPE.
Hope i clarified your doubt.
Wating for the solution.
Thank for the response.
Tejas shah