Auto Fille Cell Based on Different Cell Value [Solved/Closed]

Report
-
 Tourista -
Hello,

I wanted to know if I might be able to solicit for some help on a problem I'm looking to resolve.
Currently I use a Excel 2007 spreadsheet to trace backups in a log. In one cell Column "E", the status of job is listed, ie. Failed, Missed, In Progress. Based on the result in column "E" I would like to auto-fill the information in adjacent cell in column "F" to "Reschedule Backup", "Restart Service".
All help is greatly appreciate and Thank You All for your time.

Sincerely,
Henry B.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
762
if you have not more than 7 clauses

=IF(E1="Failed","Restart Service",if(e1="Missed", "Reschedule Backup", IF(e1="In Progress", "Wait", "")))
Rizvisa1: I owe you a burrito! Worked like a champ! Thank You so very very much!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!