View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
puukoi puukoi is offline
external usenet poster
 
Posts: 2
Default Vlookup by rows and columns

Hi All
I have workbook (Products) with sheets(January, Febr,March.........)
In row 1 I have date(C1=1,D1=2......)
In column A I have Part numbers.(part1, part2, part3,....)
In another workbook(Reports) I have sheets by weekly. I like to create
formula to find data from "Products". How many produced part1 on the
03. march or part2 on the 01. june ...
Part numbers on the columnA and date on the row20. I hope that not very
absurd question.