Auto Fille Cell Based on Different Cell Value

Solved/Closed

Tourista - Jul 14, 2010 at 05:42 PM
Tourista - Jul 15, 2010 at 09:01 AM

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.

Auto Fille Cell Based on Different Cell Value
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
Grand theft auto 1 download - Download - Action and adventure
Conditional formatting if cell contains text - Excel Forum
Grand theft auto v free download no verification for pc - Download - Action and adventure
If cell contains date then return value ✓ - Excel Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 14, 2010 at 07:01 PM

if you have not more than 7 clauses

=IF(E1="Failed","Restart Service",if(e1="Missed", "Reschedule Backup", IF(e1="In Progress", "Wait", "")))

Tourista
Jul 15, 2010 at 09:01 AM

Rizvisa1: I owe you a burrito! Worked like a champ! Thank You so very very much!

Similar discussions

help me to add particular cells

Excel - IF function with multiple words

Counting cells containing only numbers

If a cell contains any text then add a value

If cell = date return yes or no.

Similar discussions

Subscribe To Our Newsletter!