If eVestmentB8 does NOT read 'Not Available' I would like:
BrockhouseB8 to say any value the user writes in here
CambridgeB8 to say any value the user writes in here
CallanB8 to say any value the user writes in here
You cannot have a formula in the same cell that you might enter hard data into. You may need to add another column next to the one where user enters data that will choose whether to say "Not available" or the value the user entered.