Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-26-2016, 01:33 PM
BlindMouse BlindMouse is offline Using multiple conditions with an IF statement?? to show a yes/no value Windows 7 32bit Using multiple conditions with an IF statement?? to show a yes/no value Office 2010 32bit
Novice
Using multiple conditions with an IF statement?? to show a yes/no value
 
Join Date: Jan 2016
Posts: 1
BlindMouse is on a distinguished road
Question Using multiple conditions with an IF statement?? to show a yes/no value

OK folks, I'll try to be as clear as possible.



We are tracking the pre-shift safety talks given by our supervisors. All safety talks fall into one of 20ish different categories.

For each department, there are several category topics that are considered to be High Risk issues. The High Risk topics vary by department (ex: Lockout/Tagout is High Risk for Maintenance, but not for the Office department)

Currently supervisors fill out a spreadsheet to track their talks. Using conditional drop down lists, they enter the Department and the Topic of the safety talk (there are other things entered, but they're not important here).

They are also required to use a drop down list to select if the topic covered is one of the High Risk topics for that department. They are terrible at this. They get it wrong most of the time and I'm looking for a way to automate this part of the form.

Here is what I would like to have happen:

The supervisor selects the Department and the Topic of the safety talk, then a formula looks to see if that Topic is considered a High Risk Topic for that Department. If it is, then it will enter 'YES' in the High Risk column, if it is not, it will enter 'NO'.

On another sheet I have lists of the High Risk topics divided by Department (eg: cell A1 has the department name 'Maintenance', cells A2:A6 have the different topics that are considered high risk for Maintenance).

So the formula would look at the Department name entered into the form, then compare the Topic entered into the form with the list of high risk topics for that department on the other sheet and enter Yes or No into the form.

Sounds as clear as mud to me, hopefully you can give me some indication of where to go.

Thanks
Reply With Quote
  #2  
Old 01-27-2016, 12:19 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Using multiple conditions with an IF statement?? to show a yes/no value Windows 7 64bit Using multiple conditions with an IF statement?? to show a yes/no value Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Cross post without links

http://www.excelguru.ca/forums/showt...ed=1#post22245
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using multiple conditions with an IF statement?? to show a yes/no value Generating Multiple Word Docs from Master Depending on Conditions ljg713 Word VBA 6 12-09-2015 03:23 PM
Using multiple conditions with an IF statement?? to show a yes/no value Multiple If Conditions z941714 Excel 8 08-09-2015 04:12 PM
Using multiple conditions with an IF statement?? to show a yes/no value multiple conditions, and blank cells with the countifs function jaden0605 Excel 1 03-30-2014 01:50 AM
Using multiple conditions with an IF statement?? to show a yes/no value How to Use Mail Merge with conditions to show some features raiya Mail Merge 11 10-16-2012 11:04 PM
Using multiple conditions with an IF statement?? to show a yes/no value Count with multiple conditions bundy5150 Excel 4 02-22-2011 10:00 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:02 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft