View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gregc. Gregc. is offline
external usenet poster
 
Posts: 12
Default Caculating Sales using If(vlookup())

G'day

I am trying to calculate the sales figure for an organisation using
if(vlookup). What I am trying to do is lookup the item in the Item
information part of the sheet, compare it with the item in the order
information part of the sheet, and if there is a match, then multiplu
the sales price by the qty. Would anyone have any ideas?

Thanks for your help

Greg