Hi there,

First time posting in the forum but used the sage like advice from the group in the past. Today I'm looking for some assistance with the INDIRECT function. I'm creating an automated voucher where the user will select first a "fund". Each fund has varying amounts subfund info so in the cell below I want a list of only the selected fund's sub info. Ok, that's easy enough using the indirect function.

Now, when I want to set the sheet to it's original state and in the original drop down have it say "Select your fund from the drop down", how do I get the next cell to auto populate "N/A" or something to that affect? I've tried a nested If,then,indirect but it only allows me to us "N/A" as a the drop down option and I want it to do it automatically.

Pushing my luck?

Thanks in advance,

Mike in MASS