I use to think I knowe a lot about Excel - but as people ask "can you do
this?" I dont know as much as I though

In the valiation source - can a formula be entered

i.e.

=($E4="Books","NA",=INDIRECT($E4))

Becky