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!