show name when a cell has specific word

N

Noemi

Hi
How do we add into VBA a code to insert a name into a cell when another cell
has a specific word selected from a validation list.

Any help would be appreciated.

Thanks Noemi
 
B

bigwheel

Would a formula such as =IF(B1="Fred","Barney","") work for you? (assuming
your cell to be checked to be B1)
 
Top