Thanks for your response. The only problem with that is column U could have
other account numbers entered. It is only when it is tagged a "NOMAD" do I
want that field to be filled in with the information. I need the If
statement to be in a field that I am not currently using.
Thanks.

"CLR" wrote:


There are various methods to achieve what you want........to answer
specifically, to your IF question,

in U1 put this formula and copy down..........

=IF(L1="nomad",26,"")

Vaya con Dios,
Chuck, CABGx3


"dbuck9333" wrote:

Is it possible to use an if statement to enter information in one field
automatically when certain info is entered in another field?

for example when the word "NOMAD" is entered in column L, the number 26 is
automatically entered in column U.

Thank you!