hmltnangel
Active Member
- Joined
- Aug 25, 2010
- Messages
- 290
- Office Version
- 365
- Platform
- Windows
Hi folks,
Somedays we just have a complete mind blank. Today, is that day for something that should be really simple.
I have
Column C - check column - displays "Yes" or Blank
Column D - "Employee ID"
Columns F-M - Employee IDs in the Structure of Col D Employee
I want to have a formula that does the following:
If Col C = yes, then display "Yes"
or
If Col D appears in Col F-M in any row where Col C = Yes then display "Yes"
Cheers
Somedays we just have a complete mind blank. Today, is that day for something that should be really simple.
I have
Column C - check column - displays "Yes" or Blank
Column D - "Employee ID"
Columns F-M - Employee IDs in the Structure of Col D Employee
I want to have a formula that does the following:
If Col C = yes, then display "Yes"
or
If Col D appears in Col F-M in any row where Col C = Yes then display "Yes"
Cheers