The below formula is working fine, but I would like a few changes. I would like to include the YEAR and MONTH. I have basically two workbooks:
1 - Called Master_01 --> this one is where my below formula is located.
2 - Called Input for Pilot_v01 where I have the data for the formula.
Here is the formula which is located on Pilot_v01 workbook:
=INDEX('[Input for Pilot_v01.xlsx]LPAR_WCAP'!$F$2:$G$300000,SMALL(IF('[Input for Pilot_v01.xlsx]LPAR_WCAP'!$F$2:$G$300000=A2,ROW('[Input for Pilot_v01.xlsx]LPAR_WCAP'!$F$2:$G$300000)-ROW('[Input for Pilot_v01.xlsx]LPAR_WCAP'!$F$2)+1,ROW('[Input for Pilot_v01.xlsx]LPAR_WCAP'!$G$300000)+1),1),2)
Here is what I want to include on above formula
- YEAR: 2013(for example the year will be on Cell A4 of Master_01 workbook) which its data is on ('[Input for Pilot_v01.xlsx]LPAR_WCAP'!$D$2:$D$300000)
- MONTH: 01 (will be on cell A5 of Master_01 workbook)) which its data is on ('[Input for Pilot_v01.xlsx]LPAR_WCAP'!$E$2:$E$300000)
Bookmarks