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!

The best for your situation would be a vlookup function
Search help menu for VLOOKUP

"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!

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!

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!

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!