Hello,
Is it possible to perform a vlookup, or some other lookup function, against a column when the cells in that column contain multiple values?
For example, I have a STAFF ID table with two columns. Column A contains a list of staff IDs. Some cells here have a single Staff ID but other...