View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jlmccabes jlmccabes is offline
external usenet poster
 
Posts: 10
Default 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.