Thanks for your response.
The only problem with that is that column U could have other account
numbers, its only when its tagged a "nomad" would it have that particular
code. So I need a formula that can be in a field that I'm not currently
using with the results entered in column U.


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!