IF function using drop down list validation as data.

[Stevie-B]

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"

[NBVC]

In that formula both your result_if_true and result_if_false is a null... so you would always get a blank. Also you want to check that all 3 cells are equal right?

Try:

Please Login or Register  to view this content.

Then you can link your data validation list to the cell the formula is in.

[Stevie-B]

NBVC,

I knew you'd come along with help. Yes I need to add one of the workbooks for the true result.

I'll give your formula a go and feedback soon. Thanks....

As always your weight in gold is not even close.

Thanks that really helped.

Oh I need you to help me on another enquiry? Have a look at this.

If I type =3+4+3 into a cell as text what function can I use to sum the figures. Also need it to auto sum when new figures are added from time to time?

That'll fox ya!!!!!!