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 attached the sheet for the ref.
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
1 Reply
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