View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jlmccabes jlmccabes is offline
external usenet poster
 
Posts: 10
Default VLookup VS SumProduct

Was trying to Vlookup two columns on one tab, check it matched the two
columns on current tab and fill in value (Dept # - Acct # - $$$) using
Vlookup. Thought I could do it. Ended up using the SumProduct formula that
worked but do not understand what the heck it is doing with the "*" in the
middle of formula. What was SumProduct doing to bring the correct answer.
Prefer using VLookup but could not get two columns to work..