Fetching data using Index match from another sheet

[Sandip Roy]

Dear Friends,

PFA workbook, Data are in Inventory sheet.

Need the result based on a particular date of any raw material.

Pls help.

Regards
Sandip

 

[Hui]

Sheet2:
F10: =INDEX(INVENTORY!$C$8:$DV$33, MATCH($E10,INVENTORY!$B$8:$B$33,0), MATCH($A$1,INVENTORY!$C$6:$DV$6,0) +COLUMNS($F$9:F9) -1)

Copy across and down

 

[Sandip Roy]

Perfect, Hats off.

 

[Sandip Roy]

Mr. Hui,

Pls let me know one thing, suppose the source page is named as INV-Feb, and another source page is created & named as INV-Mar.

Now in sheet 2 I want to get the figures on 01-03-2017, hence I have to create a formula that will automatically search the source page based on the date that will be put. Similarly multiple number of source pages will be created on monthly basis.

Kindly help to face that situation.
Thanks in advance.
Regards
Sandip

 

[Hui]

Please ask this as a new Thread and attach a sample file

 

[Sandip Roy]

Ok Mr. Hui. have posted the new thread.

thanks
Regards
Sandip