Previous Topic Next Topic

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.
Related:

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", "")))
-1
Tourista
Jul 15, 2010 at 09:01 AM
Rizvisa1: I owe you a burrito! Worked like a champ! Thank You so very very much!
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Excel function question
1234ah -
ac3mark -

3 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses