I'm trying to create a formula that I'm not sure is even possible and would appreciate any help that I can get. What I'm tring to do is look @ a cell for a value and if the value matches, then go to look at a column of cells to create a drop down list of any cell that has a value great than zero. I'm going to try and place it in an example formula below to help give clarification:

If Cell A1 =2, then go to Cells BA1.BA250, if cells BA1.BA250>0,Use data to create a dropdown list in Cell D2
If Cell A1 =3, then go to Cells BB1.BB250, if cells BB1.BB250>0,Use data to create a dropdown list in Cell D2

I will need to check this for up to 250 in Cell A1

If the formulas are possible above, then I will need to be able to select one of the items on the dropdown list (which I will use in another formula).

Wow - this is what I need, I have no idea if it's even possible.

Thank you, in advance, for your assistance.

Regards,