• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Adding value in month wise from one excel sheets to another excel sheets

M

MAHESWAR

New Member
Dear Chandoo,
I have a raw data in excel format with 2 sheets i.e. one is GL wise Budget and other sheets to be updated number month wise from GL wise budget sheets.
But while using SUMIFS, INDEX & MATCH, first month i got the number. But when i drag it from feb to Dec it showing error. Could you help me the formula.
I have attached the working file for your reference. Please let me know where i made the mistake.
 

Attachments

you need to add $ to the A:A part
=INDEX('GL Wise Budget'!$D$3:$O$143,MATCH('Need to Update'!$C3,'GL Wise Budget'!$A:$A,0),MATCH('Need to Update'!D$2,'GL Wise Budget'!$D$2:$P$2,0))

also its best not to reference complete rows if possible - and give a large range
 
You must log in or register to reply here.
Back
Top