Wad Mabbit
Board Regular
- Joined
- Mar 31, 2016
- Messages
- 74
- Office Version
- 2016
- Platform
- Windows
I've set up this table, called PickDescription:
and this one, called PickNotes
using this lookup to check for Keywords in Notes Keywords, then Description Keywords, returning [Description] if no match:
=IFNA(INDEX(PickNotes[Category],MATCH(TRUE,ISNUMBER(SEARCH(PickNotes[Notes Keywords],[@Notes])),0)),
IFNA(INDEX(PickDescription[Category],MATCH(TRUE,ISNUMBER(SEARCH(PickDescription[Description Keywords],[@Description])),0)),
[@Description]))
Questions 1:
Is there a way to do this without using an array, as arrays are volatile?
Question 2:
It would be nice to have multiple entries in the Keyword columns, rather than lopts of rows for the same Category listing. Any ideas?
and this one, called PickNotes
using this lookup to check for Keywords in Notes Keywords, then Description Keywords, returning [Description] if no match:
=IFNA(INDEX(PickNotes[Category],MATCH(TRUE,ISNUMBER(SEARCH(PickNotes[Notes Keywords],[@Notes])),0)),
IFNA(INDEX(PickDescription[Category],MATCH(TRUE,ISNUMBER(SEARCH(PickDescription[Description Keywords],[@Description])),0)),
[@Description]))
Questions 1:
Is there a way to do this without using an array, as arrays are volatile?
Question 2:
It would be nice to have multiple entries in the Keyword columns, rather than lopts of rows for the same Category listing. Any ideas?