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.

Hi,

assuming that in workbook Reports month (January, February,...) is in
A1, month day (1-31) is in A2 and part number is in A3, the following
formula should work:

=INDEX(INDIRECT("'[products.xls]"&A1&"!A1:AE20"),MATCH(A3,INDIRECT("'[products.xls]"&A1&"!A1:A20"),0),MATCH(A2,INDIRECT("'[products.xls]"&A1&"!A1:AE1"),0))

We are assuming also that both files are in the same folder.

Does this help?
Kostis Vezerides

Hi,

Thanks,but this not working. After "Enter" showing "MATCH" error


vezerid wrote:
Hi,

assuming that in workbook Reports month (January, February,...) is in
A1, month day (1-31) is in A2 and part number is in A3, the following
formula should work:

=INDEX(INDIRECT("'[products.xls]"&A1&"!A1:AE20"),MATCH(A3,INDIRECT("'[products.xls]"&A1&"!A1:A20"),0),MATCH(A2,INDIRECT("'[products.xls]"&A1&"!A1:AE1"),0))

We are assuming also that both files are in the same folder.

Does this help?
Kostis Vezerides