Data validation list error

[Grawill]

Excel 2007

Error: "The list source must be a delimited list, or a reference to a single row or column."


How it currently works:
User selects a two digit number from a list box located at D2. The formula below populates the listbox for E2 depending on what is selected in D2. Problem is when I try to use a third list.

I've been using this code without issue:

=IF(ISNUMBER(FIND(","&$D2&",",",82,85,86,87,")),SVG10KLIST,IF(ISNUMBER(FIND(","&$D2&",",",81,83,84,")),SVGARLIST))

I've attempted to use this code:

=IF(ISNUMBER(FIND(","&$D2&",",",82,86,")),New10KList,IF(ISNUMBER(FIND(","&$D2&",",",81,83,84,")),ARList,IF(ISNUMBER(FIND(","&$D2&",",",85,87,")),Old10KList)))

named ranges:
SVGARLIST = Sheet1!$H$1001:$H$1091
SVG10KLIST = =Sheet1!$G$1001:$G$1091

Old10KList = Sheet1!$V$3:$V$100
New10KList = Sheet1!$W$3:$W$100
ARList = Sheet1!$X$3:$X$100

Thanks for any help you can provide.

Ted.

 

[Grawill]

bump.

Any suggestions?

Thanks.

 

[Grawill]

I got it with some playing around today. I was missing a ,"" at the end. Without the ,"", the last IF statement was always FALSE causing the error message.

=IF(ISNUMBER(FIND(","&$D2&",",",82,86,")),New10KList,IF(ISNUMBER(FIND(","&$D2&",",",81,83,84,")),ARList,IF(ISNUMBER(FIND(","&$D2&",",",85,87,")),Old10KList,"")))

Old10KList = Sheet1!$V$3:$V$100
New10KList = Sheet1!$W$3:$W$100
ARList = Sheet1!$X$3:$X$100