I’ve looked everywhere and can’t seem to find the answer to this one…
Here’s the scenario:
I have a list of names on one sheet.
On another sheet I have a list of data input through columns A:I. In these columns I have 5 sections where names are input (this is all pulled from an external program, unfortunately I cannot change the way this is done).
I need to find a way to make it so my table of data show only data that contains the names in the list. I currently have conditional formatting set up to highlight any row containing names on the list but so far it's missing certain names.
The current formula I'm using is =IF(ISERROR(VLOOKUP($B2,List, 1, 0)), 0, 1) with an additional formula done for each column that needs to be searched under conditional formatting. (ex: there is also a formula for C, D E, F...)
So far this works if the name is on it's own in the cell but if there are multiple it's not getting highlighted. I'm really hoping there is a
way to do this without separating each grouped name and having a conditional formatt for each column. (PS: this is a report I need to run weekly...)
I have attached a tiny example...
Please help!
Here’s the scenario:
I have a list of names on one sheet.
On another sheet I have a list of data input through columns A:I. In these columns I have 5 sections where names are input (this is all pulled from an external program, unfortunately I cannot change the way this is done).
I need to find a way to make it so my table of data show only data that contains the names in the list. I currently have conditional formatting set up to highlight any row containing names on the list but so far it's missing certain names.
The current formula I'm using is =IF(ISERROR(VLOOKUP($B2,List, 1, 0)), 0, 1) with an additional formula done for each column that needs to be searched under conditional formatting. (ex: there is also a formula for C, D E, F...)
So far this works if the name is on it's own in the cell but if there are multiple it's not getting highlighted. I'm really hoping there is a
way to do this without separating each grouped name and having a conditional formatt for each column. (PS: this is a report I need to run weekly...)
I have attached a tiny example...
Please help!