JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 591
- Office Version
- 365
- Platform
- Windows
I have a table filled via a =IF(ISERROR(VLOOKUP(N261,$Z$39:$Z$70,1,FALSE)),N261,"") formula. Randomly the data from the formula needs to be deleted/removed based on another column.
When something is entered into another column based on criteria (for example - ABC) I need all the ABC's in the ISERROR(VLOOKUP table removed/deleted. Not sure if I need to make another table to get away from the ISERROR(VLOOKUP table. Meaning another table with equals to the cells with the ISERROR(VLOOKUP formula.
Appreciate any feed back.
James
When something is entered into another column based on criteria (for example - ABC) I need all the ABC's in the ISERROR(VLOOKUP table removed/deleted. Not sure if I need to make another table to get away from the ISERROR(VLOOKUP table. Meaning another table with equals to the cells with the ISERROR(VLOOKUP formula.
Appreciate any feed back.
James