Need your help to update the value from one sheet to other sheet

[Sakthikumar Chinnasamy]

Hi,

In the attached excel sheet, there are two sheets are there "Consolidated" & "Capacity approved" sheet.

Requirement:

In the capacity approved sheet - If the Status is"Approved" and date is "Today date", then i need to get the value of either B2 or C2 and do the vlookup of F value with Consolidated sheet of C2 , and provide the output of B2 or C2 value in J2 of "consolidated" Sheet.

Please help me on this

 

[AVK]

For vlookup formula : you need atleast one one common (exact match) data in both sheets.

 

[bosco_yip]

Try,

In J2, formula copy down :

=SUMIFS('Capacity approved'!B:B,'Capacity approved'!F:F,C2,'Capacity approved'!H:H,"Approved",'Capacity approved'!I:I,TODAY())+SUMIFS('Capacity approved'!C:C,'Capacity approved'!F:F,C2,'Capacity approved'!H:H,"Approved",'Capacity approved'!I:I,TODAY())

p.s. "Capacity approved Sheet" column I "Date" some date changed to =TODAY() for testing purpose.

Regards