Great! Thank you both for the help.

"Jim Thomlinson" wrote:

Sorry missed the last else...

=IF(H19 = "IET", C4, IF(H19="BUS", C7, IF(H19="DSO", C10, IF(H19="BPO",""))))
--
HTH...

Jim Thomlinson


"Jim Thomlinson" wrote:

=if(H19 = "IET", C4, if(H19="BUS", C7, if(H19="DSO", C10, if(H19="BPO",
C13)))).
--
HTH...

Jim Thomlinson


"Ann" wrote:

This should be simple, but I'm drawing a blank here. I four different
categories with four different values and need to populate my field (in this
case, N19) based on the value for that category:

IF H19="IET" then C4, or H19="BUS" then C7, or H19="DSO" then C10, or
H19="BPO" then C13.

Can you assist in providing an appropriate formula structure for the above?