Data Validation - List Formula Issues

[cseabold08]

Hi! I am trying to have Excel create drop down list based on a cell reference. However, when I try to use the formula below it give me the message "This list source must be a delimited list, or a reference to single row or column." Thank you for the review.

=IF(N5="0B",Anchors!$AA$26:$AA$27,IF(N5="1B",Anchors!$AB$26:$AB$33,IF(N5="2B",Anchors!$AC$26:$AC$34,IF(N5="3B",Anchors!$AD$26:$AD$38,IF(N5="4B",Anchors!$AE$26:$AE$42,IF(N5="5B",Anchors!$AF$26:$AF$46,"ERROR"))))))

This is the data I am using.

 

[BigBeachBananas]

I would strongly recommend you refer to this website. It'll show step by step how to do it.

Easy Steps Excel Dependent Drop Down List Data Validation

Easy steps for Excel dependent drop down list. Conditional data validation based on other cell, Region/City. Videos, written steps, get free Excel file

www.contextures.com