IF with OR formula

[dguillen]

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!

 

[cyrilbrd]

try =IF(OR(A1="Training#1",A1="Training#2"),"X","")

 

[saelageonzon]

Hello dguillen. By 'Find' did you mean a lookup? May I take a look? Thanks

 

[Joyner]

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]

***SOLVED***

thank you everybody for your help.

 

[DigDoug]

***SOLVED***

thank you everybody for your help.

Curious what the answer was if you can share. I am running into a similar dilemma.

 

[Joyner]

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]

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!