indirect / substitute questions

When using the indirect substitue ... how can i make it so that the cell containing the sub. will also allow me to free type?


Cell A contanis list B sub look up A C sub Look up B....


I want to be able to populate A and B and free type C if a new option is needed.

Thanks

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.