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!