In D9 put formula:

=IF(C8="CHRIS", 506, "")


"Lady@scalehouse" wrote in
message ...
I WANT CELL D TO SAY A CERTAIN TRUCK# "IF" CELL C IS A CERTAIN DRIVER NAME.
ie: "IF" C8 SAYS "CHRIS", D9 SAYS 506
I keep getting errors. What am I doing wrong?