SumProduct VS Lookups
Dept Acct Hrs
Have columns with 9160 3210 160
9160 3610 80
Worksheet with ALL depts and all accts listed on it.
Need to fill it in with just the data that matches dept , acct, hrs.
Sumproduct will work, little clumsy for me, is there any way to get Vlooup
to look at both coluns on both sheets and pull the hours numbers only when
they match up.
|