Forum Discussion
Solved
Vacation Calender
Hi All Greetings I have 2 Sheets- Master and Calendar How do I bring automatically the text in this calender as I pasted the data in value based on the data entered in master. I have attach...
You may try using this array formula, when you paste this formula in your worksheet make sure hit CTRL + SHIFT + ENTER, if you just hit enter formula will not work.
=IFERROR( INDEX(Master!$B$3:$H$6, IFERROR( IFERROR(MATCH(TRUE,MONTH(C$2)=MONTH(Master!$F$3:$F$6)*($B3=Master!$E$3:$E$6),0),MATCH(TRUE,MONTH(B$2)=MONTH(Master!$F$3:$F$6)*($B3=Master!$E$3:$E$6),0)), MATCH(TRUE,MONTH(C$2)=MONTH(Master!$G$3:$G$6)*($B3=Master!$E$3:$E$6),0)), 7), "")Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com
You may try using this array formula, when you paste this formula in your worksheet make sure hit CTRL + SHIFT + ENTER, if you just hit enter formula will not work.
=IFERROR(
INDEX(Master!$B$3:$H$6,
IFERROR(
IFERROR(MATCH(TRUE,MONTH(C$2)=MONTH(Master!$F$3:$F$6)*($B3=Master!$E$3:$E$6),0),MATCH(TRUE,MONTH(B$2)=MONTH(Master!$F$3:$F$6)*($B3=Master!$E$3:$E$6),0)),
MATCH(TRUE,MONTH(C$2)=MONTH(Master!$G$3:$G$6)*($B3=Master!$E$3:$E$6),0)),
7),
"")
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com