simora
02-15-2020, 09:51 PM
I have a working formula in Column D of the attached WorkSheet.
=INDEX(Posted_Data!$BK$3:$BK$11,MATCH(B3,Posted_Data!$AT$3:$AT$11,0))
I am using this Index Match function with a hard coded range of A Sheet Named Posted_Data ,
So Posted_Data!$BK$3:$BK$11, However, I would like to make this search range Dynamic based on the value that is listed in My Formula Colum, Row 2, so that the search range changes depending on the current value of the Active Column Row 2 value
Right now, my formula is in Column D, so when I move to Column E, the search range happens to be in !$BL$3:$BL$11,
but that will NOT always be the case, so I need to first search in sheet Posted_Data Range Range BK2:BV2 for the value in ActiveCell Row2
( Finding the Appropriate month )
The formulas are in Sheets(“Report”)
How do I modify my formulas to accommodate this on the Attached WorkSheet ?
=INDEX(Posted_Data!$BK$3:$BK$11,MATCH(B3,Posted_Data!$AT$3:$AT$11,0))
I am using this Index Match function with a hard coded range of A Sheet Named Posted_Data ,
So Posted_Data!$BK$3:$BK$11, However, I would like to make this search range Dynamic based on the value that is listed in My Formula Colum, Row 2, so that the search range changes depending on the current value of the Active Column Row 2 value
Right now, my formula is in Column D, so when I move to Column E, the search range happens to be in !$BL$3:$BL$11,
but that will NOT always be the case, so I need to first search in sheet Posted_Data Range Range BK2:BV2 for the value in ActiveCell Row2
( Finding the Appropriate month )
The formulas are in Sheets(“Report”)
How do I modify my formulas to accommodate this on the Attached WorkSheet ?