Forum Discussion
Solved
Xlookup or Index match
Hello, I am needing help with a formula and I just cannot get it quite right. I have tried Xlookup, Index Match, Vlookup and something is just not quite right. I have this first table on a separate w...
See the attached sample workbook.
You may use Sumproduct.
=Sumproduct(
(Table1[WorkCenter]="FBD 2")*(Table1[ProdDate]="4/1/2022")*
Table1[Sume_Earned_Value]
)
*Don't forget to lock the cell ref of "4/1/2022" in the formula with $ sign.
For e.g $D$2.
=Sumproduct(
(Table1[WorkCenter]="FBD 2")*(Table1[ProdDate]="4/1/2022")*
Table1[Sume_Earned_Value]
)
*Don't forget to lock the cell ref of "4/1/2022" in the formula with $ sign.
For e.g $D$2.
I tried your formula but I could not get it to work. I guess I didn't understand where to lock in my cell ref of D2 because I do not see it in your example. I know a lil bit about excel but still learning formulas I have not used.