cseabold08
New Member
- Joined
- Nov 17, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
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.
=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.