exceldotcom
New Member
- Joined
- Jul 2, 2018
- Messages
- 15
Hi folks,
Parts of my census is missing, for those missing parts I'm pulling in a data-point based on an identifier having a specific phrase included. The identifier could be "Core Values", "Core Values and Leadership", "Core Values and Key Objectives", "Key Objectives". Basically if one of those phrases has the wording "Core Values" I want the data-point pulled. If it doesn't, for example "Key Objectives" then I want it ignored.
Below is the start of my formula. AA20="" just identifying the blanks. The VLOOKUP currently is just pulling the member's ID number (which is totally wrong but using as a placeholder). I believe I need to embed an IF formula within but wasn't sure of the most effective way.
=IF(AA20="",VLOOKUP(B20,'Q3 Disc'!D1:AA183,1,0),0)
Thanks!
Parts of my census is missing, for those missing parts I'm pulling in a data-point based on an identifier having a specific phrase included. The identifier could be "Core Values", "Core Values and Leadership", "Core Values and Key Objectives", "Key Objectives". Basically if one of those phrases has the wording "Core Values" I want the data-point pulled. If it doesn't, for example "Key Objectives" then I want it ignored.
Below is the start of my formula. AA20="" just identifying the blanks. The VLOOKUP currently is just pulling the member's ID number (which is totally wrong but using as a placeholder). I believe I need to embed an IF formula within but wasn't sure of the most effective way.
=IF(AA20="",VLOOKUP(B20,'Q3 Disc'!D1:AA183,1,0),0)
Thanks!