Hi,

Need yor help.

I have two sheets
1. Tracker
2. Data


I have to update my GL Balance(CAD) "H Col0umn" in Tracker Sheet, for that I will take my total sum from Sum Transaction Amt from "F Coloumn" sheet2 "DATA".


My condition is

If Bus Unit,Account,Department,Affiliate,Product in Tracker Sheet are matching with my Data sheet then I will copy the Total Sum from "Sum Transaction Amt"(F Coloumn) and

Paste it to GL Balance(CAD) "H Col0umn" in Tracker Sheet.

I have to update Tracker sheet from serial 1 to 44 on a daily basis.


I would appreciate if you could help me for the same. Please find the step and the attachment for reference.


Thanks & Regards

Santosh

I can help you if you click on GO ADVANCED and use the paperclip to upload your sample sheet.

Make sure your sample sheet includes sample results too, make sure I can see exactly where your answers came from if it's not obvious.

Hi,

My file size is heavy. I would appreciate if you could provide me the email address.

Regards

Hi
Find the attached.

Regards

Find the attached step

Regards

This is the formula needed H2 and copied down:

=INDEX(DATA!$F2:$F$200, MATCH(B2&"-"&C2&"-"&D2&"-"&E2&"-"&F2, INDEX(DATA!$A$2:$A$200&"-"&DATA!$B$2:$B$200&"-"&DATA!$C$2:$C$200&"-"&DATA!$E$2:$E$200&"-"&DATA!$D$2:$D$200, 0), 0))

I know it's the right formula, but the sheet you uploaded did not have a single item in it matching your criteria. I had to copy the values from row 2 into the DATA sheet somewhere to have it find the value and return it.