Hello,
I am trying to use an index match with dates for column BB on the Direct Sales Companies tab. I am trying to pull the value on US LEI tab Column C, that matches the year and month from Column B on the Direct Sales Companies tab. For example, cell BB3 on the Direct Sales Companies tab should return the value 106.1 from the US LEI tab because the month and year in column B of the direct sales companies tab matches the month and year on the US LEI tab. I am using the following formula, which is not returning the correct values:
={INDEX('US LEI'!$C$1:$C$179,MATCH(1,(MONTH('US LEI'!$B$1:$B$179)=MONTH('Direct Sales Companies'!$B3))*(YEAR('US LEI'!$B$1:$B$179)=YEAR('US LEI'!$B$1:$B$179)),1))}
Any suggestions?
Thanks!
Bookmarks