R
Rick Arends
I have a drop down list in cell B40. In the validation I wrote
=If(A40="","",FORTYB) where "FORTYB" is the name of a list. It worked
perfectly, only filling the list if cell 40A had data in it. I then tried to
enter the same format in B41 and it gave me an error something to the effect
of needing a delimited list. I copied the workbook and tried to redo the same
thing I had done in the original A40. Could someone tell me what I have done
wrong? I don't even know that it was supposed to work in the first place!
=If(A40="","",FORTYB) where "FORTYB" is the name of a list. It worked
perfectly, only filling the list if cell 40A had data in it. I then tried to
enter the same format in B41 and it gave me an error something to the effect
of needing a delimited list. I copied the workbook and tried to redo the same
thing I had done in the original A40. Could someone tell me what I have done
wrong? I don't even know that it was supposed to work in the first place!