IF with OR formula

dguillen

New Member
Joined
Oct 1, 2014
Messages
12
I desperately need help with figuring out a formula. I've tried many different combinations and functions. i have the majority of the sheet completed except for this portion. I need the formula to read something like this.... Find employee1 and see if he has either Training#1 OR Training#2, then put and "X" in the box. Any help would be greatly appreciated. Please let me know if you need me to send you the actual excel sheet. Thank you!
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

cyrilbrd

Well-known Member
Joined
Feb 2, 2012
Messages
4,071
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
try =IF(OR(A1="Training#1",A1="Training#2"),"X","")
 

Joyner

Well-known Member
Joined
Nov 15, 2005
Messages
1,202
Hello, maybe something like this =IF(OR(VLOOKUP(A1,B1:C1000,2,0)={"Training#1","Training#2"}),"X","")

Where Employee 1 is in A1, the matching names are in column B and Training number is in column C
 

dguillen

New Member
Joined
Oct 1, 2014
Messages
12

ADVERTISEMENT

***SOLVED***

thank you everybody for your help.
 

Joyner

Well-known Member
Joined
Nov 15, 2005
Messages
1,202
Hello DigDoug, Maybe dgilillen will provide the answer, if not, if you can provide some specifics and/or some sample data, maybe we can help.
 

dguillen

New Member
Joined
Oct 1, 2014
Messages
12
My solution was to use an "IF"&"COUNTIF" with in an "IF"&"COUNTIF" statement. Since I wanted to search for Training#1 or Training#2 I made it look something like this =if(countif(employeeX,training1)),"x",if(countif(employeeX,training2)),"x","")

and that hat did the trick. Let me know if you have any questions. Thanks again everybody!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,670
Messages
5,597,480
Members
414,143
Latest member
lonnie451

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top