Hiya everyone,
I am using 3 linked sheets (in separate workbooks) into a collective workbook. I'd like to add a nested logical function so that cell E5 which has a drop down list of months to only show the month selected on the 3 linked workbooks which all show the same month.
So if January was selected in the 3 linked sheets that would appear on the linked workbook.
The formula I'm using is below,
=IF(AND('[CAA Spreadsheet (Armagh & Dungannon).xls]Return'!$E$5,'[CAA Spreadsheet (Craigavon & Banbridge).xls]Return'!$E$5,'[CAA Spreadsheet (Newry & Mourne).xls]Return'!$E$5),"","")
The format Im using for the month is "mmmm yyyy"
Bookmarks